Difference between writing SQL query and stored procedure ?
Answer Posted / senthil kumar
compared with query, stored procedure is efficient and fast
execution.Because stored procedure is program once it
formed then execute as a program.
| Is This Answer Correct ? | 90 Yes | 26 No |
Post New Answer View All Answers
What are date and time data types in ms sql server?
Can you leave a union at any time?
What is postgresql server?
Explain try...catch with sql server?
List the advantages of using stored procedures?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
How do I make a resultset scrollable?
How to find the list of fixed hard drive and free space on server?
Explain having clause?
Can we take the full database backup in log shipping?
What is mssql?
Do you know how to send email from database?
What are the differences between DDL, DML and DCL in SQL?
What is nolock hint in sql server 2008