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
- 13348 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
what is raid and what are different types of raid configurations? : Sql server database administration
Explain the functionalities that views support?
How to create new tables with "create table" statements in ms sql server?
How can we call UDF(User Define Function) using C# code in ASP.net ?
What is relationship? What number of sorts of relationship are there?
Define right outer join in sql server joins?
What are the steps you must follow to hide sql server instances?
Explain how many types of relationship?
What do you mean by 'normalization'?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
Can you roll back the ddl statement in a trigger?
What is set nocount on?
What are points to remember while using the fillfactor argument?
What are the differences between char and varchar in ms sql server?
