SQL Query to Copy Structure and Data of One table To Other in SQLServer

How to copy structure and data of one table into another table?

Syntax: Select * into Newtable from Oldtable

Ex: select * into emp1 from emp

SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer

Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs

No comments:

Recent Posts