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 you can get the list of largest tables in a database?

943

---

How to get the query of a table in sql server?

849

---

Does partitioning ssd reduce performance?

846

---

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1891

---

What is msdb database? : SQL Server Architecture

1060

---

What are two difference between sql azure and azure tables?

159

---

Does index speed up select statements?

976

---

How to create a large table with random data for index testing in ms sql server?

978

---

Can you explain what is indexed view? How to create it?

851

---

Can You Use Data Mining Models In Ssrs?

139

---

What are ddl triggers and types of ddl trigger?

975

---

What is the ‘fillfactor’?

916

---

How to connect to SQL Azure Database by using sqlcmd?

136

---

How to run sql server 2005 books online on your local system?

917

---

How do I view a stored procedure in sql server query?

886

---