what command is used to create a table by copying the
structure of another table?
Answer Posted / naik
select * into oldtable from newtable where oldtable
=newtable
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How you can get the list of largest tables in a database?
Can we insert data into a view?
What are the advantages of sql stored procedure?
why would you use sql agent? : Sql server database administration
What is check constraint in sql server?
Explain the dbcc pintable command when would you use it?
What are clustered and non-clustered index?
What is the difference between count and distinct count?
What is the difference between clustered and a non-clustered index?
What is data source object?
What is conditional split?
When do you think a developer should use sql server-based cursors?
Do you know hot add cpu in sql server 2008?
What is inner join in sql server joins?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio