What do you mean by table and field in sql?

1066

---

What are the differences between left join and inner join in sql server?

1158

---

What is the sql case statement used for?

1136

---

How sql server executes a statement with nested subqueries?

1103

---

What is the sql case statement used for? Explain with an example?

1045

---

Explain how to send email from sql database?

1110

---

What are the different authentication modes in sql server?

1173

---

Can sql servers link to other servers?

1144

---

Describe how to use the linked server?

1208

---

What are transactions in sql?

1139

---

Explain the third normal form(3nf)?

990

---

What are the different types of collation sensitivity?

1182

---

List out the differences between global and local temp tables in sql server?

1117

---

Explain “@@rowcount” and “@@error” in sql server?

1138

---

What are the different types of join?

1246

---