How will u test the stroded procedures and functions?
difference between SP and Triggers




Answers were Sorted based on User's Feedback



How will u test the stroded procedures and functions? difference between SP and Triggers..

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

How will u test the stroded procedures and functions? difference between SP and Triggers..

Answer / surya

we can write store procedure without table also..but not
triggres..

Is This Answer Correct ?    1 Yes 0 No

Post New Answer




More SQL Server Interview Questions

How will u get 5 years back record?

5 Answers  


How to truncate a table first before running a package?

1 Answers  


What is Online Index Rebuild Operation?

1 Answers  


Explain Capacity planning to create a database? and how to monitor it?

0 Answers  


How send email from database?.

3 Answers   Merrill Lynch, CarrizalSoft Technologies,






default databases available in sql server and there uses ?

4 Answers   TCS,


How to get the count of distinct records. Please give me the query?

8 Answers   Value Labs,


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

0 Answers  


Diff. b/w Full Outer Join And Cross Join?

3 Answers  


What is the role that is required for killing a process What is the role that is required for creating a linked server

1 Answers   IBM, CarrizalSoft Technologies,


what is the difference between procedure and function.

4 Answers   Thomson,


How To delete duplicate record from a particular table?

12 Answers   eXensys, Foxfire,






Categories