Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they.
- 5 Answers
- 13383 Views
- IBM, I also Faced
- E-Mail Answers
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
Is it possible for a stored procedure to call itself or recursive stored procedure?
What is the difference between ddl,dml and dcl commands?
How to verify the port number of the sql server?
What are filegroups in sql server?
How to read data in a table with "select" statements?
What is the sql server agent?
how to determine the service pack currently installed on sql server? : Sql server database administration
Can we call future method from trigger?
What is a transact-sql statement?
How to defragment indexes with alter index ... Reorganize?
Do you know sql server 2008 introduces automatic auditing?
What are the difference between clustered and a non-clustered index?
How will you hide an attribute? : sql server analysis services, ssas
What is an indexing strategy?
How to handle error or exception in sql?
