Answer Posted / latha.s

select distinct * from tablename;

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

475

---

How to call a function from a stored procedure in SQL Server ?

547

---

Which is faster statement or preparedstatement?

526

---

Explain what are the authentication modes in sql server?

500

---

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

468

---

---

What is a fan-out query in SQL Azure?

99

---

How to link tables in sql server?

473

---

Can select statements be used on views in ms sql server?

580

---

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

5928

---

What is the difference between locking and multi-versioning?

529

---

What is the distinction amongst delete and truncate?

583

---

What are the two authentication modes in sql server?

600

---

How can a database be repaired?

564

---

How to start sql server browser service?

556

---

Tell me what are the essential components of sql server service broker?

506

---