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

What is raid? : SQL Server Architecture

1162


What are the commands used in DCL?

1012


How many null values we can have in a unique key field in sql server?

940


how you can move data or databases between servers and databases in sql server? : Sql server administration

952


Explain comment on transactions?

970


What is join query?

877


What is deploy, process and build? : sql server analysis services, ssas

1094


What are the advantages of using cte?

1004


What is instead of dml trigger?

990


What are filegroups in sql server?

1053


What is the use of tempdb? What values does it hold?

1057


How to update values in a table with update statements in ms sql server?

998


Comment,Datatypes are unlimited

2055


After removing a table from database, what other related objects have to be dropped explicitly?

1037


What is server-level principal?

122