26 June 2012

Script for renaming column in table in Sql Server


Script for renaming column in table in Sql Server :

sp_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN'



-

No comments:

Post a Comment

Comments Welcome

Subscribe to: Post Comments (Atom)

Finding duplicate records in SQL Server

 Finding duplicate records in SQL Server 1. The GROUP BY and HAVING Method This is the most standard approach. It is best used when you on...