What are the differences between stored procedure and
functions in SQL Server 2000?
Answer Posted / satish kr verma
Some of the differeneces are mentioned below
Function -
1) Have to return a single value to the calling program
2) Can call functions in sql statements
3) Cannot return images
Procedures -
1) Do not return any value except assigning values to OUT
variables
2) Cannot call procedures in sql statements
3) Can return images
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How and why use sql server?
What is data set in report?
What is a domain constraint give an example?
What is instead of trigger sql server?
What do you mean by tablesample?
How many replicas are maintained for each sql azure db?
Difference between primary key and clustered index?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
Difference between 2NF &3NF ?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
How to rename databases in ms sql server?
How do I install only the client tools of sql server 2000?
What is transact-sql ddl trigger?
What are the differences between decimal and float in ms sql server?
Explain an incremental backup?