What is sub-query in sql server? Explain its properties.

1 Answers  

---

What is the user of Primary key?

1 Answers  

---

How maney row would be print after join if A table have 100 rows and B table have 50 rows...

9 Answers   Hewitt,

---

write query for fourth maximum salary from employee table

14 Answers   Mind Tree, SP Software,

---

what are the different types of replication you can set up in sql server? : Sql server database administration

1 Answers  

---

Can we rewrite subqueries into simple select statements or with joins? Example?

2 Answers   ASD Lab,

---

What are “lock” hints?

1 Answers  

---

What are the differences between char and varchar in ms sql server?

1 Answers  

---

How adventureworkslt tables are related?

1 Answers  

---

How to modify an existing stored procedure in ms sql server?

1 Answers  

---

What is partition in sql server?

1 Answers  

---

What is nonclustered index with included columns ?

1 Answers  

---