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 is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What is the architecture of ms sql reporting service?
Explain filtered indexes?
What is difference between joins and subqueries?
How to replace given values with null using nullif()?
what method you can use to reduce the overhead of Reporting Services data sources?
What is partition index in sql server?
What are the restrictions while creating batches in sql server?
How do triggers work?
What is subreport?
What is lock escalation? : sql server database administration
How many columns can we include on clustered index ?
What is the server name for sql management studio?
how to invoke a trigger on demand? : Sql server database administration
What are window functions in sql server?
