Answer Posted / arvind rohit

SELECT IDENT_CURRENT('table_name') ;

What are the advantages of using a stored procedure?

1008

---

What is the difference between composite index and covering index?

952

---

Explain different types of Normalization.

1832

---

When would you use it?

994

---

Do you know how to send email from database?

1005

---

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1106

---

Tell me what is de-normalization and what are some of the examples of it?

1043

---

Why use update_statistics command in sql server?

1049

---

Define self join in sql server joins?

948

---

How to return the second 5 rows in ms sql server?

1058

---

How to select some specific rows from a table in ms sql server?

1005

---

What do you mean by subquery?

1087

---

Can we insert data into view sql server?

927

---

Tell me what are the advantages of using stored procedures?

1012

---

Determine when an index is appropriate?

1076

---