How will u test the stroded procedures and functions?
difference between SP and Triggers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / surya
we can write store procedure without table also..but not
triggres..
Is This Answer Correct ? | 1 Yes | 0 No |
Explain different backup plans?
Can we use custom code in ssrs?
What are the differences between union, intersect, and minus operators?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
How to use clusters?
What is dknf in normalization form?
Explain the difference between cross join and full outer join?
What is nested transaction?
If a table does not have a unique index, can a cursor be opened on it?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
What is blocking?
What are the pros and cons of creating extended stored procedures?