Category: SQL

Renaming Tables in SQL Server

Post author By Andy B.
Post date Jan 3, 2021
No Comments on Renaming Tables in SQL Server

Renaming tables, that’s easy right? Renaming a Table Performing the rename of a table is straight forward in Management Studio via Object Explorer. You can simply select the table and right click and Rename (or press F2) and edit the name right there and then. Hit return and we’re good to go. If you’re scripting […]

SQL

Commenting with Care

Post author By Andy B.
Post date Oct 25, 2020
1 Comment on Commenting with Care

Comments are a wonderful thing whether it’s keeping track of your thoughts in a drawn out stored procedure, or leaving some breadcrumbs to follow when revisiting code in the future. There is, however, a slightly uglier side to these when you’re trying to look at queries as they run. Let’s suppose we’re running a very […]