Answer Posted / chandra deo mahto

START File_name or @<File_Name>

Can group functions be used in the order by clause in ms sql server?

588

---

How do I edit a procedure in sql server?

548

---

What is use of @@ spid in sql server?

681

---

How to replace given values with null using nullif()?

574

---

What is GUID in sql server?

641

---

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

554

---

What is compression - row-level and page-level compression?

533

---

What is the difference between delete and truncate statements?

568

---

How to transfer data from a cursor to variables with a "fetch" statement?

582

---

Can you explain what is the use of custom fields in report?

603

---

What are the advantages of stored procedure in sql server?

466

---

How many categories of data types used by sql server?

595

---

What do mean by xml datatype?

617

---

How to execute multiple stored procedures at one time in sql server?

506

---

How do you drop an index?

503

---