How will u test the stroded procedures and functions?
difference between SP and Triggers
Answer Posted / anand vanam
What is the difference between Functions and Stored
Procedures?
Answer:
1. Stored procedure supports deferred name resolution: but
Function won’t support deferred name resolution.
2. Stored procedures return always an integer value by
default zero. Where as function Scalar (single value or
table or row set)
3. Stored procedures are precompiled execution plan but
functions are not.
4. The result of the user defined function can be used with
in a sql server statement. Where as the result of stored
procedures can’t be used in sql server statements.
5. Stored procedure allows all functionality provided by a
function but the reverse is not true.
6. Functions in sql server can be one of two different types
1.scalar, 2. Table
Stored procedures are 2 types. 1. Regular sp, 2. Temporary
sp
Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What are the requirements on sql server network connections?
Why normalization is used?
Can you explain various data region available in ssrs with their use?
What is a ddl statement?
When do you think a developer should use sql server-based cursors?
What are constraints?
Is it possible to replicate data from sql server to oracle? : sql server replication
Where do we use trace frag?
How do I find the sql server database version?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
Explain how to send email from sql database?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
How do you test your database? : sql server database administration
What are the different types of cursor?
Can another user execute your local temporary stored procedures?