What is the difference between "dynamic SQL" and "stored procedure" ?

Posted by Chikul on 12/21/2009 | Category: Sql Server Interview questions | Views: 5016

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

Dynamic sql is the bunch of statements that dynamically constructed at run time and not stored in database.
Where as Stored procedures are stored in data base in complied form.

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What is the maximum number of cookies that can be ...

Next > : What type of Authentication does Microsoft SQL Ser ...

Comments or Responses

More Interview Questions by Chikul

What type of Authentication does Microsoft SQL Server support?
What exactly a Constructor is doing ?
What is the use of COALESCE function in SQL Server ?
Can you store multiple data types in System.Array?
What is the Magic Tables in Sqlserver2000?
What is a Join in SQL Server?
How to get number of Maximum connection can be establish to SQL
What is the difference between UNION ALL Statement and UNION

Latest Interview Questions

What is next number in this series? 1, 3, 4, 8, 15, 27,_
Find out next number in this series? 0, 2, 3, 5, 8, 10, 15, 17, 24, 2 ...
What is next number in the series 1,2,3,5,7,11,_
What will be next number in this series. 2, 5, 9, 19, 37,__
What is difference between var and Dynamic ?
What is PLINQ
What is dynamic keyword ?
There is one word in the English language that is always pronounced in ...
More ...