What types of integrity are enforced by a foreign-key constraint

1 Answers  

---

How will u test the stroded procedures and functions? difference between SP and Triggers

2 Answers   TCS,

---

How to determine the service pack currently installed on SQL Server?

4 Answers   HCL,

---

How to resolve the orphan use problem? : sql server security

0 Answers  

---

What is difference between commit and rollback when used in transactions?

0 Answers  

---

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 Answers  

---

How to change location of errorlog in SQL?

2 Answers   ABC, IBM,

---

Can we drop user if user mapped to any logins

1 Answers  

---

List some case manipulation functions in sql?

0 Answers  

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

0 Answers   Facebook,

---

Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60

3 Answers   IT Decisions,

---

What is Schema? and why we use schemas?

4 Answers  

---