Wht is the difference between stored procedure and trigger

6 Answers   HCL, TCS,

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

What are the types of normalization?

0 Answers  

---

what is the disadvantage of SQL Loder?

1 Answers   TCS,

---

What are the different types of cursor?

0 Answers   HCL,

---

---

Explain ranking functions?

0 Answers  

---

What are the steps you can take to avoid “deadlocks”?

0 Answers  

---

How do I find the port number for sql server?

0 Answers  

---

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers   HCL, Wipro,

---

How to install sql server 2005 express edition?

0 Answers  

---

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

1 Answers  

---

How to encrypt Strored Procedure in SQL SERVER?

0 Answers  

---