Subscribe to this blog
Vivek's SQL Notes
Vivek johari is currently a Analyst and
have more that 5.5 yeras of experience in database. He has Master
degree in Computer and also he is Microsoft certified Sql DBA
(MCTS)& Microsoft certified SQl BI professional(MCTS). He is also
Oracle certified profession(OCP)DBA in ORACLE 10g and ORACLE 9i.He has
the experience of working in PL/SQL, T-SQL and SSIS/SSRS. His work
basically involved designing and optimization of the Database.He has
also published many database articles on his blog Technologies with Vivek Johari.
Archives: September 2010
Renaming a column in Sql Server
We often need to change the name of a column of a table to a new name. We can do this with the help of the Exec Sp_rename command.
The Syntax of the Sp_rename is given below:-
Exec sp_rename 'TableName.[OldColumnName]', '[NewColumnName]', 'Column'
For example, suppose we have a table…
The Syntax of the Sp_rename is given below:-
Exec sp_rename 'TableName.[OldColumnName]', '[NewColumnName]', 'Column'
For example, suppose we have a table…
0 comments, 194 reads
Posted in Vivek's SQL Notes on 6 September 2010
Thanks for supporting this blog and make it successful
Hi friends
Thank you very much for supporting this blog. It really give me lots of encouragement to share my knowledge with my friends. Due to some other high priorities, I was not able to publish any articles on this blog from last few months. But now I am busy…
Thank you very much for supporting this blog. It really give me lots of encouragement to share my knowledge with my friends. Due to some other high priorities, I was not able to publish any articles on this blog from last few months. But now I am busy…
0 comments, 71 reads
Posted in Vivek's SQL Notes on 2 September 2010