u cannot change any datatype in database using udf u can do everything w

Differnce between Stored procedure and user defined functions?

Question Posted / saiprasad

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

Please Help Members By Posting Answers For Below Questions

What is the difference between data reader and data adapter?

972

What are the advantages of ado.net?

860

What is the difference between Command and CommandBuilder object?

1127

What is the role of clr?

902

List all the steps in order, to access a database through ado.net?

1037

What is executequery?

905

Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?

1101

What is difference between ado and other data object?

874

How can we serialize the dataset object?

963

What is difference between Dataview and Datatable?

1007

How is it possible to get 2 tables of data at a time by using data reader?

911

Which provider is used to connect ms access, oracle, etc…?

951

What are the features of ado.net?

965

Is it possible to load multiple tables in a Dataset?

1010

What is linq and entity framework?

947