Answer Posted / guest

Pointer is a variable which stores memory address of any
variable

How many types of triggers are there?

768

---

What is the default port for SQL Server over a firewall?

780

---

What are the advantages of sql stored procedure?

754

---

What are user defined functions in ms sql server?

682

---

Does view occupy space?

697

---

---

Explain about system database?

791

---

Explain what is row_number function?

755

---

can we have a nested transaction? : Sql server database administration

694

---

How to write an inner join with the where clause in ms sql server?

753

---

What are the different types of stored procedures?

789

---

Does partitioning help performance?

682

---

What are different types of subquery?

906

---

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

1759

---

What is create statement?

679

---

What is the xml datatype?

804

---