Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How will u test the stroded procedures and functions?
difference between SP and Triggers

Question Posted / anand

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

Explain features of analysis services?

0 Answers  

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

0 Answers  

Describe how to use linked server?

0 Answers  

what is difference between nchar and char in Sql server ?

3 Answers  

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers  

What is factless fact table? : sql server analysis services, ssas

0 Answers  

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

0 Answers   ABC,

Mention the different types of replication in sql server.

0 Answers  

Explain Active/Active and Active/Passive cluster configurations?

1 Answers  

How to delete duplicate records based on single column from a table?

0 Answers   Petranics Solutions,

What are the different types of stored procedures?

0 Answers  

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

2 Answers   IBM,

For more SQL Server Interview Questions Click Here
Categories