How will u test the stroded procedures and functions?
difference between SP and Triggers
- 2 Answers
- 7022 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
How many types of attribute relationships are there? : sql server analysis services, ssas
Explain what are the restrictions while creating batches in sql server?
Is null in sql server?
How do I create a partition table in sql server?
What are the different types of sql server replication? : sql server replication
How column data types are determined in a view?
Explain the advantages of merge replication?
How many databases can we create in a single server?
Tell me in brief how sql server enhances scalability of the database system?
How can I create a report based on a query? : sql server management studio
What is BLOCK statements in SQL?
Detail about the hardware which is supported by SQL server?
Can we install sql server 2016 on windows 7?
Can binary strings be converted into numeric or float data types?
Give an example of SQL injection attack ?
