Answer Posted / veeresh kethari

1.By using case.. set,we can avoid the cursors

2.By using temporary tables/table variables/CTE
with while loop we can avoid cursor in the transaction.

What is a unique key constraint?

970

---

Write a SQL command to insert and update only a particular field?

1036

---

What is xml datatype?

1029

---

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1066

---

What are the properties of the transactions?

1053

---

How can you stop stored procedures from recompiling?

848

---

What are the different types of collation sensitivity in sql server?

1034

---

what is bit datatype? : Sql server database administration

864

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

941

---

how to take backup bcp out for a column in table in sql server?

2043

---

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

931

---

Does a full backup include transaction log?

906

---

In which format does an image save in SQL Server database ?

945

---

What is cursors?

1094

---

How to return the date part only from a sql server datetime datatype?

1021

---