Why use cursor in sql server?

1090

---

Write the syntax for stuff function in an sql server?

1037

---

What does man by sql wildcard characters in sql server?

1072

---

Explain about unique identifier data type in sql server?

924

---

List all types of constraints in sql server?

1057

---

What are views used for?

1025

---

What are constraints?

1022

---

What are the triggers in sql?

1117

---

How to use “drop” keyword in sql server and give an example?

1141

---

What are the advantages of user-defined functions over stored procedures in sql server?

1057

---

Are null values the same as that of zero or a blank space?

1055

---

What is the temp table?

934

---

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

1204

---

List some advantages and disadvantages of stored procedure?

1025

---

What factors you will consider calculating the storage requirement for that view?

957

---