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

How to enable and disable connection pooling?

1060

What does executenonquery () method return?

939

How do you update database through dataset?

988

Explain ado.net features? Benefits? Drawbacks?

1052

Explain how to create dynamic gridview?

982

What is the difference between statement and preparedstatement interface?

999

What is Data view?

1081

How to maintain the relation between two tables in ADO.NET?

1013

Explain the namespaces in which .net has the data functionality class.

1092

Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

1112

What is sqldatareader in ado.net?

922

Explain the dataadapter class in ado.net?

1211

What is microsoft ole db provider for sql server?

933

What is the difference between linq and ado.net?

999

What is data control techniques?

962