What is Schema in Database?

1 Answers   Cap Gemini,

---

Explain trigger classes i.e. Instead of and after trigger?

0 Answers  

---

Explain identity in sql server?

0 Answers  

---

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,

---

i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L

8 Answers  

---

---

What is difference between after and before?

0 Answers  

---

Difference between Inner vs outer joins?

0 Answers  

---

Mention the command used to rename the database.

0 Answers  

---

Why we use the openxml clause?

0 Answers  

---

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

0 Answers   ABC, TCS,

---

Can you name some of the dml commands in sql?

0 Answers  

---

How will you monitor replication latency in transactional replication? : sql server replication

0 Answers  

---