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 are different replication agents and what's their purpose? : sql server replication
What are the different Authentication modes in SQL Server and how can you change authentication mode?
How to filter records of table in SQL SERVER?
What are orphan records?
What is ms sql server triggers?
What does select 1 mean?
How do I create a stored procedure in dbml?
What is the difference between seek predicate and predicate?
How adventureworkslt tables are related?
What is 2nf normalization form?
if no size is defined while creating the database, what size will the database have? : Sql server administration
What is change data capture (cdc) in sql server 2008?
Why use “in” clause in sql server?
How do you set a trace flag in sql server?
What are the restrictions that views have to follow? : SQL Server Architecture
