Interested to Buy Any Domain ? << Click Here >> for more details...
difference between function and procedure
- 3 Answers
- 5505 Views
- Cognizant, HCL, TCS, Theorem, I also Faced
- E-Mail Answers
Answer Posted / manub22
- Stored Procedures can contain a single SQL statement or a group of SQL statements with data flow control logic containing IF-ELSE, WHILE loop constructs, TRY-CATCH, transactions, etc.
SPs are used to return one or many result-sets to its calling application.
- On the other hand Functions or UDFs can contain single or multiple SQL statements depending on its type. A Scalar UDF & Inline UDF can only have a single SELECT statement. And a Multi-Statement UDF can contain a body with multiple SQL statements including SELECTS, IF-ELSE, WHILE loops and DMLs but limited to manipulating table variables only.
UDFs return a single Scalar value or a Table variable to the calling SELECT statement.
Check all the difference here:
http://sqlwithmanoj.com/2011/09/21/stored-procedures-vs-functions-difference-between-sp-udf/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to end a stored procedure properly in ms sql server?
What are the character string functions supported by sql server 2005?
Explain “not null constraint” in sql server?
Which joins are sql server default?
Explain “@@rowcount” and “@@error” in sql server?
How to create a large table with random data for index testing in ms sql server?
Can you name a few encryption mechanisms in sql server?
How can we rewrite sub-queries into simple select statements or with joins?
What is the use of sign function?
What are the triggers in sql?
Can we add a cpu to sql server?
What do you need to connect php to sql server?
Explain system views?
Is ssrs support other database except ms sql server?
What is the process of normalising?
