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

What is the difference between windows authentication and sql server authentication

7 Answers   HCL,


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 ?

0 Answers  


In the primary key have a multiple field or not?

8 Answers   TCS,


What command do we use to rename a db?

5 Answers  


Which command executes the contents of a specified file?

2 Answers   ABC, InfoMedia,






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..

4 Answers  


what is checksum in sql server.........???

0 Answers   TCS,


How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?

15 Answers   Synechron, Leo Technologies, Mannar Company,


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???

3 Answers  


What is Trace flag?

1 Answers   Wipro,


How to find the date and time of last updated table?

3 Answers  


What is stored procedure in SQL..??

2 Answers  






Categories