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
- 13386 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / pratap557
In general SPs are sequential block of PL/SQL for
Transaction
Func are used for specific calculation / selection
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain “@@rowcount” and “@@error” in sql server?
What are group functions in query statements in ms sql server?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
Explain syntax for disabling triggers?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What are the Advantages of using CTE in sql server?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
how you can move data or databases between servers and databases in sql server? : Sql server administration
what's the maximum size of a row? : Sql server database administration
What is the report model project?
What happens if ntwdblib.dll is missing on your machine?
Explain the properties of a relational table?
What are the differences between decimal and float in ms sql server?
Why we need to use secondry database file? though, we can do same work using primary database file also.
