Answer Posted / rajkumar

Format
------
Inser into <tablename> (column name) select (column name)
from <tablename> where <Condition>

Example
--------
INSERT INTO emp (empname) SELECT empname from employe WHERE
empid=5

What is abstracting periodical?

990

---

What is instead of dml trigger?

1054

---

Where to find ntwdblib.dll version 2000.80.194.0?

1007

---

What are the recovery models in sql server 2000?

999

---

Explain system rowset functions?

1043

---

Tell me what is sql profiler?

1083

---

What is the temp table?

974

---

Write a SQL command to insert and update only a particular field?

1190

---

Explain what are partitioned views and distributed partitioned views?

1013

---

What are 3 ways to get a count of the number of records in a table?

1122

---

How does normalization work?

971

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

1003

---

What is the contrast amongst drop and truncate?

1078

---

What encryption security is available in sql azure?

101

---

Explain the use of keyword with encryption. Create a store procedure with encryption?

1006

---