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

hi,i want t0 knom d syntax for a super key with an example

1 Answers  


what is trigger . hw will it use them

2 Answers   TCS,


How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

3 Answers   SAP Labs,


how to select 5 to 7 rows from a table, which contains 10 rows?

21 Answers   IBM,


How do we get current date in SQL Server 2000, Oracle, MS Access?

13 Answers  






As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,


What are the different types of replication? How are they used?

3 Answers  


4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10

7 Answers  


What is DAC? what is the use of it?

1 Answers   Wipro,


What is the difference between HAVING clause and the WHERE clause?

7 Answers  


How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS?

1 Answers   GE,


From where can you change the default port?

3 Answers  






Categories