Explain what is scheduled job and how to create it?

0 Answers  

---

What is the use of partition by in sql server?

0 Answers  

---

Tell me what is the significance of null value and why should we avoid permitting null values?

0 Answers  

---

What the difference between UNION and UNIONALL?

0 Answers   HCL,

---

What is a partitioned view?

0 Answers  

---

---

Security Question- SQL DBA exparts, need your help...

3 Answers  

---

what is checksum in sql server.........???

0 Answers   TCS,

---

how to implement locking in sql server

3 Answers   Satyam,

---

How can you stop stored procedures from recompiling?

0 Answers  

---

Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,

---

write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?

8 Answers  

---

What is the difference between functions and stored procedures?

0 Answers   Accenture,

---