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
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
|Is This Answer Correct ?||9 Yes||2 No|
Answer / surya
we can write store procedure without table also..but not
|Is This Answer Correct ?||1 Yes||0 No|
How will u get 5 years back record?
How to truncate a table first before running a package?
What is Online Index Rebuild Operation?
Explain Capacity planning to create a database? and how to monitor it?
How send email from database?.
default databases available in sql server and there uses ?
How to get the count of distinct records. Please give me the query?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
Diff. b/w Full Outer Join And Cross Join?
What is the role that is required for killing a process What is the role that is required for creating a linked server
what is the difference between procedure and function.
How To delete duplicate record from a particular table?