How to handle error or exception in sql?

0 Answers  

---

what is trigger . hw will it use them

2 Answers   TCS,

---

Explain the phases a transaction has to undergo?

0 Answers  

---

How to implement service broker?

0 Answers  

---

Differentiate between delete and truncate.

0 Answers  

---

What is a select query statement in ms sql server?

0 Answers  

---

How to execute stored procedure and set temp table in sql server?

0 Answers  

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

What is a materialized view?

3 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers  

---

What is xml datatype?

0 Answers  

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

0 Answers  

---