How to override dml statements with triggers?

0 Answers  

---

Tell me extended events in sql server 2008?

0 Answers  

---

what protocol both networks use? : Sql server database administration

0 Answers  

---

Where the sql logs gets stored?

0 Answers  

---

What are defaults? Is there a column to which a default can't be bound?

2 Answers   TCS,

---

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

What is difference between Triggers and store procedure?

2 Answers  

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,

---

Which tcl commands are available on the sql server?

0 Answers  

---

how to implement locking in sql server

3 Answers   Satyam,

---

Mention the command used to rename the database.

0 Answers  

---