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

What is sql server replication? : sql server replication

0 Answers  

---

What is an identity?

0 Answers  

---

What is Primary key and foreign key? Give an example

4 Answers   TCS,

---

What is the difference between rank and dense_rank?

0 Answers  

---

Can you explain what are commit and rollback in sql?

0 Answers  

---

How do I delete a sql server database?

0 Answers  

---

Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

3 Answers   Accenture,

---

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

0 Answers  

---

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

0 Answers   Global Logic,

---

What is policy based management (pbm)? : sql server database administration

0 Answers  

---

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

What is Command line parameters in PLSQL.?

0 Answers   MCN Solutions,

---