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

Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer

3 Answers  

how would you improve etl (extract, transform, load) throughput?

0 Answers   LinkedIn,

Are semicolons required at the end of sql statements in sql server 2005?

0 Answers  

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  

Explain DBCC?

0 Answers   QuestPond,

What is filter index?

0 Answers  

can you any body tell me why are go for the rebuild the master database.what is the reason?

2 Answers  

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

0 Answers  

What is the parse query button used for?

0 Answers  

what are the problems in logshipping?

3 Answers  

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

0 Answers  

What are the different Authentication modes in SQL Server and how can you change authentication mode?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories