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
- 13126 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
In how many ways you can invoke ssrs reports?
Do you know what is difference between stored procedure and user defined function?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How to concatenate two strings in SQL Server.
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
What is truncate table?
What does it mean if @@cursor_row returns a negative number?
Can you index views?
Can I save my report as html, excel or word? : sql server management studio
What is the difference between a function and a stored procedure?
Differentiate sql server reporting services vs. Crystal reports?
What are user-defined functions (udfs) in sql server?
Explain Geography datatype in SQL Server
What are system databases into sql server (2005/2008) : sql server database administration
Explain the various types of concurrency problem?
