Write a SQL query to make a column as unique?

0 Answers   Cap Gemini,

---

Do you know exporting and importing utility?

0 Answers  

---

write down the code for "how we delete a table without using of Drop command " ?

7 Answers   CarrizalSoft Technologies, Sonata,

---

What is a cursor in SQL Server 2000 and their types?

8 Answers  

---

Explain about protocol layer present in SQL server?

0 Answers  

---

What is resource governor?

0 Answers  

---

Where do we use trace frag?

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  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

How to drop existing views from a database in ms sql server?

0 Answers  

---

What is difference between equi join and inner join?

0 Answers  

---

Repair mdf file

2 Answers  

---