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|
Difference Between varchar and nvarchar datatype?
What is the STUFF function and how does it differ from the REPLACE function?
How can u convert the Date to String?
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
Alternative way to DetDate() function?
What is a cursor in SQL Server 2000 and their types?
Why we need to use secondry database file? though, we can do same work using primary database file also.
explain different types of jions with examples briefly?
What is SQL server agent?
What is sorting and what is the difference between sorting and clustered indexes?
How to find the last update record in SQL Server?
what is mean by constraints in sql?