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
- 7890 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 is schemabinding a view?
Difference between Sql server reporting services and Crystal reports?
What is the maximum size per database for sql server express?
How to get the definition of a stored procedure back?
Do you know what is normalization of database? What are its benefits?
What is the use of builtinadministrators group in sql server? : sql server security
How do you improve the performance of a SQL Azure Database?
What is 3nf normalization?
How to use union to merge outputs from two queries together in ms sql server?
Is mysql better than sql server?
What command would you use to add a column to a table in sql server?
What are .mdf files?
How to delete exactly duplicate records from a table?
What is the difference between for trigger and after trigger?
What is the stored procedure?
