What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they.
Answer Posted / darshan shah
SP may return value or may not ,function always treturn
value.
SP cannot use in sselect statment or in sql stattment ,We
can use Function in any where in sql statment.
Packeage is set of statment,SP,Function Which run one by
one statment in that.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Do you know how to send email from database?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
What are the new scripting capabilities of ssms? : sql server management studio
What is the chart in report?
How to create a login account in ms sql server to access the database engine using "create login" statements?
what are database files and filegroups? : Sql server database administration
What is self contained multi valued query?
Tell me what is sql profiler?
What is the parse query button used for?
What is normalization process?
how would you improve etl (extract, transform, load) throughput?
Which language is supported by sql server?
What is the difference between web edition and business edition?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
Explain the dirty pages?