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
What are the different Authentication modes in SQL Server and how can you change authentication mode?
How to use subqueries with the exists operators in ms sql server?
can an order by clause be used in a creation of a view?
How to access the deleted record of an event?
Mention the differences between local and global temporary tables.
what does the automatic recovery do? : Sql server administration
Do I need a report server to run reports in my application?
Differentiate between a local and a global temporary table?
How can you know if the row fetched from cursor is still valid in underlying table?
What are the key configuration files for sql server reporting services ?
Is sql server a database?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What are approximate numeric data types in ms sql server?
Explain the advantages of merge replication?
Do you know what is bit data type and whats the information that can be stored inside a bit column?