Answer Posted / pappu

magic tables are created by great magician Mr.Muthukad....
for further details u have to contact him...

whats new about truncate in sql server 2008?

2509

---

What is the recovery model?

1001

---

What is the log shipping?

1023

---

How to use order by with union operators in ms sql server?

1028

---

What does nvl stand for?

950

---

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1092

---

Explain syntax for dropping triggers?

939

---

What is the meaning of resultset type_scroll_insensitive?

960

---

Explain what is meant by replication of database?

1047

---

Explain how you can deploy an SSRS report?

154

---

What types of Joins are possible with Sql Server?

1131

---

Does sql server 2016 have ssms?

969

---

What is the purpose of the model database?

1029

---

What is difference between aggregate and analytic function?

946

---

What are the differences between user defined functions and stored procedures?

1081

---