Explain candidate key, alternate key, and composite key?

0 Answers  

---

Can we call stored procedure in view in sql server?

0 Answers  

---

optimization techinques

0 Answers   Wipro,

---

What are temporal tables in sql server 2016?

0 Answers  

---

How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn't have a Monitor server and Witness server?

2 Answers   IBM,

---

---

What are the basic functions for master, msdb, model, tempdb and resource databases?

0 Answers  

---

write the query for taking database restore in sql?

2 Answers  

---

How to replace null values in expressions using isnull()?

0 Answers  

---

Why we need a group by clause?

4 Answers  

---

how many joins we can write if at all we have n no of tables

5 Answers   Tanla Solutions, TS,

---

How get current date in SQL server 2000

4 Answers   Cap Gemini, Polaris,

---

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,

---