What are the differences between stored procedure and the dynamic sql?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Explain the first normal form(1nf)?

0 Answers  


what is a join? : Sql server database administration

0 Answers  


How to view the error log for any specific instance? : sql server database administration

0 Answers  


Why we need a group by clause?

4 Answers  


hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  






What are the differences between left join and inner join in sql server?

0 Answers  


what is database replicaion? : Sql server database administration

0 Answers  


Do you know what is bit data type and whats the information that can be stored inside a bit column?

0 Answers  


what is difference between primary key and Unique

8 Answers  


How to download microsoft sql server 2005 express edition?

0 Answers  


if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,


How you would rewrite the sql query to return the customerid sorted numerically?

0 Answers  


Categories