Answer / 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

Why do we use stored procedures in sql server?

0 Answers  

---

What is scan table/view and seek table/view when its occurs? : sql server database administration

0 Answers  

---

What functions can a view be used to performed?

0 Answers  

---

What is trigger explain with program?

0 Answers  

---

How to list all field names in the result set using mssql_field_name()?

0 Answers  

---

---

How do you set a trace flag in sql server?

0 Answers  

---

Explain transaction server consistency?

0 Answers  

---

what is the maximum size of a row? : Sql server database administration

0 Answers  

---

how many type of subquery?

2 Answers  

---

What is the difference between Stored Procedures and triggers?

0 Answers   HCL,

---

What is transaction server auto commit?

0 Answers  

---

How to restore performance issues and how to check?

0 Answers  

---