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|
What is the difference between windows authentication and sql server authentication
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
In the primary key have a multiple field or not?
What command do we use to rename a db?
Which command executes the contents of a specified file?
i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..
what is checksum in sql server.........???
How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?
Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???
What is Trace flag?
How to find the date and time of last updated table?
What is stored procedure in SQL..??