What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they.
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 are rows and columns?
last function used in MS Access to convert sql what function will use in sql
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What is a print index?
What is sub-query in sql server?
What is de-normalization and what are some of the examples of it?
is there a column to which a default can't be bound? : Sql server database administration
What are the types of ssrs?
What is the difference between createstatement and preparedstatement?
What is a domain constraint give an example?
If a table does not have a unique index, can a cursor be opened on it?
Can you explain different types of locks in sql server?
How to modify an existing stored procedure in ms sql server?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
How to encrypt Strored Procedure in SQL SERVER?