Microsoft.NET 2.0 Question:

Download Job Interview Questions and Answers PDF

Explain How to rename a table using sql queries?

Microsoft.NET 2.0 Interview Question
Microsoft.NET 2.0 Interview Question

Answer:

exec sp_rename 'oldTableName' , 'newTableName'

Use server side for secure validation. Use client side for fast,user friendly validations.

Execute sp_rename 'oldtablename', 'newtableaname'

sp_rename OldTableName, NewTableName

Download Microsoft.NET 2.0 Interview Questions And Answers PDF

Previous QuestionNext Question
What is interface and abstract class in .Net?A developer company sends dlls to the client. some client is not happy current functionality, so request some modification. developer made some changes and send new dll to all clients. Some client is happy with old version, tell me minimal change to so that neither clients get affected?