Answer Posted / stephen tharkey

I think it is better but still need improvement.

How can we call UDF(User Define Function) using C# code in ASP.net ?

6837

---

How to list all triggers in the database with sys.triggers in ms sql server?

1026

---

Using the customer, and order table in northwind database, please write a query to produce xml?

1027

---

How ssrs maintain security?

1033

---

What is equi join with example?

1051

---

What is clustered primary key?

977

---

If no size is defined while creating the database, what size will the database have?

947

---

What is the difference between nvl and nvl2?

912

---

How do you migrate data from mssql server to azure?

165

---

What is the difference between for auto and for nested?

956

---

What is the difference between varchar and varchar(max) datatypes?

1023

---

Benefits of Stored Procedures?

938

---

Explain the properties of sub-query in sql server?

968

---

After removing a table from database, what other related objects have to be dropped explicitly?

1016

---

What is the syntax to execute the sys.dm_db_missing_index_details?

989

---