Sql Server: How to rename a column

Posted by Sqltimes
On August 9, 2014
0 Comments

Quick one today: Sometimes, we need to rename some column names. Surprisingly, there is no intuitive way to rename a column name in Sql Server i.e. ALTER TABLE statement type method. We need to use a system stored procedure called sp_rename. Example Below: The sample code below, renames the column ‘PKID’ in ‘dbo.ProductAttribute’ table to […]

Posted by Sqltimes
On August 2, 2014
0 Comments

Quick one today: Sometimes, for some scripts, viewing execution statistics for IO and TIME help measure the improvement you make with code changes. They could be enabled with the following T-SQL: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 -- -- Enable IO and TIME execution statistics for […]

Sql Server: How to rename a column

Sql Server : Enable execution STATISTICS for IO and Time for queries