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
- 7758 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
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
How do you run a trace?
What is proper subset of candidate key?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
Do you know how to implement service broker?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
What are the limitations in ssrs on sql server express edition?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
What the different components of Replication and what is their use?
Do you know what is lock escalation?
What are partitioned views?
What are user defined functions in ms sql server?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Where is my database stored on the hard disk in ms sql server?
What is measure group, measure? : sql server analysis services, ssas
