Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between stored procedure and
functions in SQL Server 2000?
- 25 Answers
- 113680 Views
- College School Exams Tests, HCL, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / chandu
17) Difference between stored procedure and functions?
Stored Procedures
I) Stored procedure takes input and output parameters.
II) Stored procedure contain all DML operations with
permanent table
III) Return statement can return single numeric value.
Functions:
I) functions takes only input parameters
II) function contains only select statement to perform
operation with permanent table
III) It returns single value or set of rows.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
How do we Backup SQL Azure Data?
What is a transaction and why is it important?
How to end a stored procedure properly in ms sql server?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
What is difference between count (*) and count column?
How to check status of stored procedure in sql server?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
What do you mean by an execution plan? How would you view it?
What is the use of “join” in sql server?
Describe in brief system database.
What is correlated subquery in sql server?
How to configure and test odbc dsn settings?
What is exclusive locks?
What is lock escalation and what is its purpose?
How to filter records of table in SQL SERVER?
