Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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…

Read more

0 comments, 332 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…

Read more

0 comments, 236 reads

Posted in Vivek's SQL Notes on 2 September 2010