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

Differnce between Stored procedure and user defined functions?

Answer Posted / saiprasad

u cannot change any datatype in database using udf

u can do everything with a storedprocedure

udf cannot be used in XMl Clause but sp's can be used

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different methods available under the sqlcommand class to access the data?

1099


What is ole2 format?

965


What is the difference between sqlcommand and sqldataadapter?

1041


Does sqlclient and oledb class share the same functionality?

984


What are datareaders?

1026


How many major types of connection objects in ADO.NET?

1085


Define data adapter?

1021


What is the default Timeout for SqlCommand.CommandTimeout property?

1067


What are typed and untyped dataset?

1149


What is data control techniques?

1002


Define atomicity?

1091


oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?

2449


What is the provider being used to access oracle database?

1045


What is ado and rdo?

964


Explain the difference between data reader and data adapter?

1017