Question { Wipro, 10907 }

What provider ADO.net use by default ?

Answer

sqlclient

Question { Symphony, 23847 }

Differnce between Stored procedure and user defined functions?

Answer

1.UDF can't use a nondeterministic functions such as Getdate
(),RAND() where as StoreProcedure cn use such a functions.
2.UDF must return a value or a single resultset . Store
Procedure can return a value or even multiple resultsets,
but doesn't have to
3. UDF can be used in anywhere sql statements like
where/having/Select sections where as store procedure
cannot be.
4.UDFs that return table can be treated as another rowset.
This can be used in JOINS with other table