What are the elements of dbms?

0 Answers  

---

How you would rewrite the sql query to return the customerid sorted numerically?

0 Answers  

---

How to handle errors in Stored Procedures.

2 Answers   Accenture,

---

Do you think BCNF is better than 2NF & 3NF? Why?

0 Answers   Ernst Young,

---

Can Having clause be used without Group by clause?

6 Answers   CarrizalSoft Technologies, CSC, CTS,

---

What command is used to create a database in the sql server and how?

0 Answers  

---

How to concatenate two binary strings together?

0 Answers  

---

What is trigger ?

7 Answers   Cap Gemini, SQL,

---

Difeerence between ssis 2005 and ssis2008?

1 Answers   Convergys,

---

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

---

What are the advantages of user defined function?

0 Answers  

---

What happens if date-only values are provided as date and time literals?

0 Answers  

---