difference between truncate, delete aur drop?

2 Answers  

---

If user is owning any SQL Objects, can we drop that user

0 Answers  

---

How do you simulate a deadlock for testing purposes

1 Answers  

---

Tell me what is difference between clustered and non clustered index?

0 Answers  

---

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

---

---

What are points to remember while using the fillfactor argument?

0 Answers  

---

What is the difference between getdate and sysdatetime?

0 Answers  

---

What are the character string functions supported by sql server 2005?

0 Answers  

---

Can we call a function that has out parameter in select statement

0 Answers   Nagarro,

---

How dts is used to extract, transform and consolidate data?

0 Answers  

---

What is the system function to get the current user's user id?

3 Answers   TCS,

---

Explain what are partitioned views and distributed partitioned views?

0 Answers  

---