Answer Posted / anil

Cursor allow row by row fetching records

Explain the various types of concurrency problem?

1193

---

What is the difference between Normalization and De-normalization?

1091

---

What is sqlservr.exe - process - sql server (sqlex?press)?

1108

---

Can a trigger be created on a view?

956

---

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

940

---

When should you use an instead of trigger?

955

---

Can you edit the .rdl code associated with a linked report?

163

---

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

1073

---

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

1137

---

What is a trigger in sql server?

1172

---

Do you know the capabilities of cursors?

1150

---

What is blocking?

1064

---

What is efficiency data?

950

---

Can another user execute your local temporary stored procedures?

985

---

How to connect to a sql server using odbc_connect()?

1152

---