What is difference between stored procedure and function?
Answer Posted / rakesh
mojor difference is
function must return a value but a
procedure may or may not return a value
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Do comments need to go in a special place in sql server 2005?
What command is used to delete a table from the database in the sql server and how?
Do you know what are the ways available in sql server to execute sql statements?
What are the steps you will take to improve the performance of a poor performing query?
What is the advantage of sql server?
Explain transaction server explicit transaction?
Explain ms sql server reporting services vs crystal reports?
If no size is defined while creating the database, what size will the database have?
How to find the version of sql server? : sql server database administration
Do you know what guidelines should be followed to help minimize deadlocks?
How to include text values in sql statements?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What is the difference between index seek vs. Index scan?
what are user defined datatypes and when you should go for them? : Sql server database administration
What do you mean by sql server 2005 express management tools?