Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Function and Stored Procedure?
- 9 Answers
- 22115 Views
- C1 India, NA, I also Faced
- E-Mail Answers
Answer Posted / mohammad sajid
Although both functions and sp's are prcomiled sql
statements there exists some differences between them.
1. Functions must return a value(scalar,inline table or
multi statement table) whereas stored proc may or may not
retun a value.
2.Functions can return a table whereas stored procs can
create a table but can't return table.
3. Stored procs can be called independently using exec
keyword whereas function are called using select statements.
4. Stored procs can be used to change server configuration
(in terms of security-i.e. setting granular permissions of
user rights) whereas function can't be used for this
5. XML and output parameters can't be passed to functions
whereas it can be with sp's.
6.transaction related statement can be handled in sp
whereas it can't be in function.
7. stored procedures can call a funtion or another sstored
proc similarly a function can call another function and a
stored proc.The catch with function is that no user defined
stored proc can be called.Only extended/system defined
procs can be called.
Hope this will be helpful and if there's any correction let
me know.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to list all triggers in the database with sys.triggers in ms sql server?
How to get a list of columns in a view using the "sp_help" stored procedure?
Why do we need normalization?
How to reaname table name without using sp_Rename in sql server..?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
What encryption security is available in sql azure?
What is openrowset sql server?
Describe and explain about SQL native client?
What is the significance of master, tempdb and model databases?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
Does windows server 2016 come with sql server?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
How to connect a database with sql express.?
What is relationship? What number of sorts of relationship are there?
What is Extended user-defined?
