Answer / Supriya Chaudhary

"Triggers are special types of stored procedures that automatically execute in response to specific events on a database object such as insert, update, or delete. There are four types of triggers in SQL Server: INSERT trigger (fires when new data is inserted), UPDATE trigger (fires when existing data is modified), DELETE trigger (fires when existing data is deleted), and AFTER trigger (fires after the event has occurred) and DDL Triggers (fires when any schema change happens on a database object)."n

How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

2 Answers   247Customer,

---

How to download and install microsoft sql server management studio express?

1 Answers  

---

what is difference between having and where clause ?

3 Answers  

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

What happens if you add a new index to large table?

1 Answers  

---

Delete duplicate rows without using rowid.

1 Answers   Nagarro,

---

Explain what is use of dbcc commands?

1 Answers  

---

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 Answers  

---

How do indexes help, types?

1 Answers  

---

What is BCP? When do we use it?

2 Answers  

---

What do you mean by collation recursive stored procedure?

1 Answers  

---

What’s the distinction between dropping a info and taking a info offline?

1 Answers  

---