wat new abt truncate in sql server

2 Answers   HCL, HP,

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  

---

List out the different types of locks available in sql server?

0 Answers  

---

How can we rewrite sub-queries into simple select statements or with joins?

0 Answers  

---

How to set a database state to offline in ms sql server?

0 Answers  

---

What is the use of floor function in sql server?

0 Answers  

---

What are window functions in sql server?

0 Answers  

---

i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee

3 Answers   NIIT,

---

If we shrink the Databse and Files, how much size is decreased?

1 Answers   TCS,

---

how to create a scrollable cursor with the scroll option? : Sql server database administration

0 Answers  

---

What does it mean to manipulate data?

0 Answers  

---

Can foreign key be deleted?

0 Answers  

---