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

What do mean by xml datatype?

1103

---

how many clustered indexes can be created on a table? : Sql server database administration

1152

---

What is RAID? What are the different types of RAID configurations?

1136

---

Explain the steps needed to create a scheduled job?

934

---

Should you normalize audio?

943

---

What is dknf in normalization form?

1052

---

Characterize join and name diverse sorts of joins?

968

---

Define master database?

1075

---

what is a traditional network library for sql servers? : Sql server database administration

957

---

What is the default sql server instance name?

1036

---

How will you find out if there are expensive SQL statements running or not?

1015

---

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2075

---

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

1007

---

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

978

---

How the authentication mode can be changed?

1132

---