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

Explain which name space is used to get assembly details?

530

What is the default timeout specified for "sqlcommand.commandtimeout" property?

549

What is ado full form?

506

What are the essential features of ado.net?

544

What is ole db query?

530

Explain the architecture of ado.net?

543

What is the difference between dataset and datatable?

490

What are the different execute methods of Ado.Net?

555

How can you add or remove rows from the datatable object of dataset?

583

What is a column variable?

505

Why do we use sqldataadapter?

487

What are the rules to implement connection pooling?

513

Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

461

What is an example of ordinal data?

491

What are two important objects of ADO.Net?

556