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 to delete multiple rows with one delete statement in ms sql server?

1025

---

What is the difference between indexing and hashing?

1169

---

What is the difference between sdf and mdf?

1300

---

How do I start sql server agent automatically?

973

---

How to find index size for each index on table?

1003

---

What is the purpose of update statistics and scope_identity() function?

1100

---

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

985

---

what's the information that can be stored inside a bit column? : Sql server database administration

1035

---

How many triggers you can have on a table?

995

---

Will count(column) include columns with null values in its count?

1094

---

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

989

---

what is the difference between Delete and Truncate command in SQL

1147

---

What is an indexed view?

960

---

Explain the difference between delete,drop and truncate in SQL Server?

1103

---

Does sql server use t sql?

1027

---