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
Explain what is row_number function?
What is checkpoint in sql server?
How to find the list of fixed hard drive and free space on server?
Give a example to search fr a string in all stored procedure in sql server.
What do you mean by stored techniques? How would we use it?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
what is normalization? Explain different levels of normalization? : Sql server database administration
How to make remote connection in database?
How to create user messages with print statements in ms sql server?
Explain how many normalization forms?
What is difference between views and stored procedures?
Differentiate between ms sql server reporting services vs crystal reports?
How to choose all records from the table?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
Can group functions be used in the order by clause in ms sql server?