What do you mean by table and field in sql?

1027

---

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

1116

---

What is the sql case statement used for?

1113

---

How sql server executes a statement with nested subqueries?

1044

---

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

1010

---

Explain how to send email from sql database?

1061

---

What are the different authentication modes in sql server?

1136

---

Can sql servers link to other servers?

1099

---

Describe how to use the linked server?

1156

---

What are transactions in sql?

1077

---

Explain the third normal form(3nf)?

956

---

What are the different types of collation sensitivity?

1138

---

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

1074

---

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

1099

---

What are the different types of join?

1189

---