What is a partitioned view?

0 Answers  

---

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

0 Answers  

---

What are the types of subquery?

0 Answers  

---

Do you know what is a with(nolock)?

0 Answers  

---

Define union, union all, minus, intersect?

0 Answers  

---

---

Can primary key be a foreign key?

0 Answers  

---

What is the language structure to add a record to a table?

0 Answers  

---

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

---

What do you mean by an execution plan?

0 Answers  

---

Explain primary key?

0 Answers  

---

What are the features of Embedded SQL

0 Answers   HCL,

---

What is normalization and denormalization in sql server?

0 Answers  

---