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
- 13186 Views
- IBM, I also Faced
- E-Mail Answers
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
Where can you add custom error messages to sql server?
Explain what is raid and what are different types of raid levels?
What are the disadvantages of indexes?
What is create command?
What are the approximate numeric data types?
Do you know what are the properties of the relational tables?
How to create new databases with "create database" statements?
What is the use of @@spid?
What is the difference function and stored procedure?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
What is provisioning, billing and metering, and connection routing concepts in the service layer?
How to how to convert numeric expression data types using the convert() function??
Why do we need normalization?
What is a data collection table?
Explain about sql server login?
