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/

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

0 Answers  

---

What are the events recorded in a transaction log?

0 Answers  

---

When should you use an instead of trigger?

0 Answers  

---

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

0 Answers  

---

How get current date in SQL server 2000

6 Answers   Cap Gemini,

---

What is dirty read?

0 Answers  

---

What are the aggregate and scalar functions?

0 Answers  

---

How would you use user_constraints table in DB?

0 Answers   Wipro,

---

Different Types of Functions ?

2 Answers   Satyam,

---

What command is used to rename the database?

0 Answers  

---

What is meant by indexing files?

0 Answers  

---

What are the mathematical functions supported by sql server 2005?

0 Answers  

---