What is identity?

0 Answers  

---

How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 Answers  

---

What is cube dimension? : sql server analysis services, ssas

0 Answers  

---

What is the difference between TRUNCATE and DROP?

0 Answers  

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

0 Answers  

---

---

please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.

1 Answers   TCS,

---

What are the differences between union, intersect, and minus operators?

0 Answers  

---

syntax for deleting the database in T SQL

5 Answers  

---

How do you troubleshoot errors in a SQL Server Agent Job?

0 Answers  

---

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

0 Answers  

---

how to copy only distinct data into another table which is not already exist in database?

2 Answers   Spectra,

---

What are xml indexes?

0 Answers  

---