Answer / praveen

Static queries are the queries we normally use like SELECT *
FROM EMPLOYEE. where as dynamic queries can be built and
executed dynamically. sp_executesql system stored procedure
is used to execute dynamic sql statements.

Eg: sp_executesql N'select * from employee'

dynamic sql queries will take more time to execute when
compared to static queries

Answer / 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 find the login name linked to a given user name?

0 Answers  

---

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

---

What are views in ms sql server?

0 Answers  

---

What is inner join? Explain with an example?

0 Answers  

---

How do I find the transaction log size in sql server?

0 Answers  

---

What is a not null constraint?

0 Answers  

---

What are various aggregate functions that are available?

0 Answers  

---

How to get @@error and @@rowcount at the same time?

0 Answers  

---

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  

---

When a primary key constraint is included in a table, what other constraints does this imply?

0 Answers  

---

How to connect a database with sql express.?

0 Answers   MCN Solutions,

---

How can you hide the sql server instances?

0 Answers  

---