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
What are the different methods available under the sqlcommand class to access the data?
What is ole2 format?
What is the difference between sqlcommand and sqldataadapter?
Does sqlclient and oledb class share the same functionality?
What are datareaders?
How many major types of connection objects in ADO.NET?
Define data adapter?
What is the default Timeout for SqlCommand.CommandTimeout property?
What are typed and untyped dataset?
What is data control techniques?
Define atomicity?
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?
What is the provider being used to access oracle database?
What is ado and rdo?
Explain the difference between data reader and data adapter?