One of the important interview question in Dotnet.
how to change table name in SQL server
Syntax:
Sp_rename 'oldtablename','newtablename';
Example:
Sp_rename 'emp','employee';
how to change table name in SQL server
Syntax:
Sp_rename 'oldtablename','newtablename';
Example:
Sp_rename 'emp','employee';
Really a good technical site,keep on writing good stuffs
ReplyDeletedot net training in chennai
thank you
Deletebest site please post new articles
ReplyDeletePdf download using asp.net....
ReplyDeletehttp://www.dotnetawesome.com/2014/02/how-to-export-database-data-to-pdf-file-using-aspnet.html
thank you
Delete