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
- 13128 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / pratap557
We cannot write DML in Function whereas in SPs we can
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Define cursor locking
Do you know the capabilities of cursors?
How to replace null values in expressions using isnull()?
How to achieve Paging of records in SQL SERVER?
How retrieve field names from the table in SQL through JAVA code?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Explain syntax for dropping triggers?
What is measure group, measure? : sql server analysis services, ssas
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
What is sql injection and why is it a problem? : sql server security
Explain different forms of normalization?
What is a Join and explain its types?
Can we take the full database backup in log shipping?
Explain differentiate between a having clause and a where clause?
Can a table have 2 primary keys?
