Dont divert from the main question

Good question

Following are the key differnces between Stored procedure and UDF.

1.User defined Function returns only one value; It may be the one value of table...

Hi jag

Really nice observation/experience..

I'll be also waiting for answer...

Vidyadhar

Being able to substitute parameters in sp_executesql offers these advantages to using the EXECUTE statement to execute a string:

• Because the actual text of the Transact-SQL statement in the...