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

What are the differences between stored procedure and
functions in SQL Server 2000?

Answer Posted / sathishraj

*The DML statements INSERT, UPDATE, and DELETE cannot be
used on base tables
*SQL functions that return non-deterministic values are not
allowed to be called from inside User Defined Functions.
GETDATE is an example of a non-deterministic function.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we call stored procedure in trigger?

994


What is the usage of the sign function?

1188


What is the report builder?

143


Explain how to use linked server?

1029


how can u get last observation in an unknown dataset ?

2483


How to read data in a table with "select" statements?

1024


What is the data type of time?

1012


Which joins are sql server default?

1063


What is a recursive stored procedure in sql server?

1239


What is difference between sql and sql server?

1076


What is the command dbcc checkdb used for?

1067


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2268


Can you explain the disadvantages/limitation of the cursor?

1051


How to download and install sql server 2005 books online?

1264


What command would you use to add a column to a table in sql server?

1354