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 difference between sqldatareader and sqldataadapter?

579

What is ado circle?

746

How to connect and retrieve data from database using dataset

619

What is a control toolbox?

580

How can we load multiple tables in a dataset?

648

What do you know about ado.net's methods?

669

How to creating a SqlCommand Object?

674

Is it possible to load multiple tables in a Dataset?

617

What are the different ado.net namespaces?

705

What is the difference between data reader and data adapter?

631

How to identify the updated rows in a dataset?

610

What is the use of data grid?

590

How to pass values into a datatable?

690

What is method to get XML and schema from Dataset? getXML() and get Schema ()

625

What is the default Timeout for SqlCommand.CommandTimeout property?

612