Differences between Stored Procedures and Functions

Kabwla.Phone

22 Nov 2011CPOL

2.4K

Functions can not use any function or procedure that has a time(ing) based element. For example you can not use GetDate() because it obiously is time based.You can not use NewId() because GUIDs are just fancy timestamps, and thus time based.You can not use the print statement because the...

Only logged in members can view this content

Please go to the SQL Server Table of Contents to view the list of available articles in this section.

Closed because the post is not clear, or is incomplete and has not been phrased in a way that allows it to be fully understood.. Reported by Afeefajmal on Friday, December 2, 2011 2:55pm