What are the differences between stored procedure and
functions in SQL Server 2000?
Answer Posted / srinivas
Stored procedures are a set of actions already written and
stored inside the database for acheiving a particular task
where as functions are general database objects which are
used for general purpose programming
| Is This Answer Correct ? | 46 Yes | 27 No |
Post New Answer View All Answers
What are the functions in sql server?
How to transfer an existing table from one schema to another schema in ms sql server?
How to create “dependant” parameter “make, model, year”
What is the meaning of resultset type_scroll_insensitive?
What do you understand by check constraint in sql server?
Mention the differences between local and global temporary tables.
What is the tcp/ip port on which sql server runs?
Can we use where and having clause together?
What is in place upgrade in sql server?
What is merge statement?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What is change data capture (cdc) feature?
Explain about service Broker functions?
What is the ‘fillfactor’?
What is the use of sign function?