What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they.
Answer Posted / scorpio.mishra
1->stored procedure can not be written as a column name but
function can be written as a column name
2->result set of stored procedure can not be used in
joining tables but table return by function can be used in
joins
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
What is user-defined inline table-valued function?
How to Update from select query in sql server?
What is sparse columns of sql server 2008?
What is the recovery model? List the types of recovery model available in sql server?
How to find out the list schema name and table name for the database?
How do you set a trace flag in sql server?
How do I find the default sql server instance?
Explain linked server in sql?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
How do I create an extended event in sql server?
What is the difference between char and varchar2 datatype in sql?
Explain what is lock escalation?
What is the rdl file?
Define Joins?
What is the bookmark lookup and rid lookup?