What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they.
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
Does partitioning help performance?
What are the types of lock supported by ?
Explain database normalization?
If the job running very slow what is the action you do
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
How to encrypt Strored Procedure in SQL SERVER?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What is BCNF? How is it better than 2NF & 3NF?
Explain the categories of stored procedure?
How do I open port 1433?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
What are the database roles? : sql server security
How to replace null values in expressions using isnull()?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What stored by the msdb? : sql server database administration