Answer Posted / chandra rekha

Raiseerror command is used to generate user defined error
messages.Syntax is as follows: RAISEERROR
('Message',sevierity,state)
message is the user defined error message
sevierty defines the seriousness of the error (1 to 25)
state defines the number of places from where the error
might get generated

Explain the microsoft sql server delete command?

1019

---

What is the difference between the 2 operating modes of database mirroring?

1112

---

How to convert numeric values to integers in ms sql server?

1093

---

How many full-text indexes can a table have?

974

---

How do I install sql server?

890

---

How you can add messages to the nt event log from within a stored procedure?

1069

---

What is Replication?

1047

---

List some of the rules that apply to creating and using a ‘view’

888

---

What is the bookmark lookup and rid lookup?

998

---

What does it mean if @@cursor_row returns a negative number?

992

---

Are all views updatable ?

1152

---

When should you use an instead of trigger?

955

---

What does sql server mean?

1068

---

How to populate a table in sql server?

962

---

What xml support does the sql server extend?

1012

---