what command is used to create a table by copying the
structure of another table?
Answer Posted / pradip jain
SELECT * INTO tblNew FROM tblOld WHERE 1=2
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the instances when triggers are appropriate?
What is mscorsvw.exe - process - microsoft .net framework ngen?
Why should one not prefix user stored procedures with ‘sp_’?
How to transfer data from a cursor to variables with a "fetch" statement?
what are constraints? Explain different types of constraints? : Sql server database administration
What are the pre-defined functions in the sql server?
what is the information that can be stored inside a bit column? : Sql server database administration
role of sql sever 2005 in database rather than any other database
What specific conditions database should meet, before you can bulk copy data into it using bcp?
What is the difference between migration and upgradation in sql server?
what stored procedure would you use to view lock information? : Sql server administration
How to list all login names on the ms sql server?
What is b tree index?
Mention the differences between substr and charindex in sql server.
What are the benefits of normalization?