Interested to Buy Any Domain ? << Click Here >> for more details...
How will u test the stroded procedures and functions?
difference between SP and Triggers
- 2 Answers
- 7606 Views
- TCS, I also Faced
- E-Mail Answers
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 methods do you follow to protect from sql injection attack?
How to integrate the ssrs reports in application?
What are user defined functions in ms sql server?
What are a database and a data warehouse?
Is it ok to shrink transaction log?
What protocol does sql server use?
Where actually sql azure database is hosted?
What does REVERT do in SQL Server 2005?
what are the core components of SSRS?
Explain system functions or built-in functions? What are different types of system functions?
Is the log file is a part of file group?
What is a dataset and what are the different types of datasets?
what are the different types of SSRS reports?
How to list all triggers in the database with sys.triggers in ms sql server?
Explain ranking functions?
