What is acid properties?

0 Answers  

---

What do you think of this implementation? Can this be implemented better?

0 Answers  

---

What is better - 2nd Normal form or 3rd normal form? Why?

2 Answers   TCS, TPK,

---

What is a ddl statement?

0 Answers  

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

Give an example of why you would want to denormalize a database

0 Answers  

---

how to delete duplicate rows from table

9 Answers   CSC,

---

can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

1 Answers   Cap Gemini, TCS,

---

What is Cross Join and in which scenario do we use Cross Join?

0 Answers   QuestPond,

---

What is the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---

Differentiate between delete and truncate.

0 Answers  

---

How you can change a cross join into an inner join?

0 Answers  

---