Answer Posted / manoj

Static Queries are permanent and cannot be changed during run-time, like: "SELECT * FROM Employees"

Dynamic Queries can be changed during run-time as they are created by using variables and these variables contain parts of SQL Query, like:

DECLARE @SQL VARCHAR(MAX)
DECLARE @WHENSQL VARCHAR(2000)
DECLARE @SEARCHSQL VARCHAR(500)

SELECT @WHENSQL = 'EmployeeID'
SELECT @SEARCHSQL = '100'

SELECT @SQL = 'SELECT * FROM Employees WHERE ' + @WHENSQL + ' = ' + @SEARCHSQL

EXEC (@SQL)
-- or
EXEC sp_executesql @SQL


For more interview Questions on SQL Server: http://sqlwithmanoj.wordpress.com/interview-questions/

How many types of local tables are there in sql server?

976

---

What is buffer cash and log cache in sql server?

1180

---

Do you know what are different types of replication in sql server?

1151

---

What happens if null values are involved in datetime operations?

1020

---

How can i Relate Tables in SSIS

1134

---

between cast and convert which function would you prefer and why?

1010

---

What is join query?

936

---

How to backup SQL Server Reporting Services ?

152

---

Explain about thread and memory management process of SQL?

1014

---

Can you explain what is sql server english query?

1051

---

What is 1nf 2nf and 3nf?

951

---

What are types of scd? : sql server analysis services, ssas

1072

---

How to see the event list of an existing trigger using sys.trigger_events?

1125

---

What are the dmvs?

1068

---

How do I find the sql server instance name?

1010

---