What is the purpose of floor function?

0 Answers  

---

How do you find the number of rows in a table?

7 Answers  

---

Can a trigger be created on a view?

0 Answers  

---

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

0 Answers  

---

Diffrent types of function

1 Answers   Wipro,

---

---

Can we rollback records deleted by a truncate statement?

3 Answers   CarrizalSoft Technologies, United Healthcare,

---

What are “lost updates”?

0 Answers  

---

What specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

---

What will happen when a Rollback statement is executed inside a trigger?

1 Answers   Flextronics, Hexaware,

---

What are group functions in query statements in ms sql server?

0 Answers  

---

What is Primary key and foreign key? Give an example

4 Answers   TCS,

---

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

---