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


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 pivot and unpivot?

0 Answers  


Please illustrate physical database architecture? : SQL Server Architecture

0 Answers  


Can you explain powershell included in sql server 2008?

0 Answers  


When I run the sql server 2000 setup, it just hangs. What do I do?

0 Answers  


How can we Use Linked Server? Uses of Linked server

1 Answers   IBM,


How can I enforce to use particular index?

1 Answers   Symphony,


How do you measure the performance of a stored procedure?

3 Answers   Infosys,


two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

1 Answers  


difference between sql server2000 and sql server2005

1 Answers   KPMG,


What is a unique key constraint?

0 Answers  


What is BCP? When do we use it?

2 Answers  


What are the limitation of the Online Index Rebuild Operation?

1 Answers  


Categories