Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / madhav
BY USING 'ON THE FLY TABLES'
CREAT TABLE EMPLOYEE AS SELECT * FROM EMP WHERE 1=2;
(FOR TABLE STRUCTURE)
-----TO INSERT THE EMP TABLE VALUES-------
INSERT INTO EMPLOYEE(SELECT * FROM EMP);
(INSERT THE EMP TABLE DATA)
SELECT * FROM EMPLOYEE;
-----------ALL THE BEST-------------
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What types of replication are supported in sql server?
Give me any three differences between Truncate and Delete.
What is the exact numeric data type in sql?
Which tcl commands are available on the sql server?
How many replicas are maintained for each sql azure db?
Where is trigger in sql server?
What is blocking and how would you troubleshoot it? : sql server database administration
What are the types of containers in ssis?
What is the purpose of linked server configuration in sql server?
What is parameterized reports in ssrs ?
What is partition index in sql server?
What is policy management?
Explain what are the events recorded in a transaction log?
What is 4nf in normalization form?
what are the different stages of Report Processing?
