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/

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2495

---

what is create database syntax? : Sql server database administration

1093

---

Mention the different types of triggers?

1098

---

Define right outer join in sql server joins?

1032

---

What are the High-Availability solutions in SQL Server and differentiate them briefly?

1134

---

What command is used to rename the database?

1003

---

What is an example of a primary key?

971

---

What is sql injection and why is it a problem? : sql server security

1118

---

Explain various data region available in ssrs with their use?

921

---

What is not null constraint?

1102

---

Describe how to use the linked server?

1133

---

Explain try...catch with sql server?

1015

---

Tell me what is the significance of null value and why should we avoid permitting null values?

973

---

What security features are available for stored procedure?

1026

---

Write a SQL query in order to merge two different columns into single column?

1028

---