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-------------

How to create sub reports?

226

---

What is scd (slowly changing dimension)? : sql server analysis services, ssas

954

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1129

---

Can a table be moved to different filegroup?

920

---

How to list all schemas in a database?

1005

---

How to divide query output into multiple groups with the group by clause in ms sql server?

965

---

How can you control the amount of free space in your index pages?

1012

---

Define constraints and give an example of their use?

985

---

Where in ms sql server is ’100’ equal to ‘0’?

1021

---

What is database dimension? : sql server analysis services, ssas

1034

---

What do you need to connect php to sql server?

1041

---

How to Check if table exists in sql server?

1075

---

What do you understand by replication in sql server?

997

---

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1082

---

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2707

---