Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SET DATEFIRST 1 in UDF errors out with...
Message
 
 
To
25/06/2002 06:02:56
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00671930
Message ID:
00671968
Views:
12
According to BOL, SET commands aren't allowed in the function body. See CREATE FUNCTION in BOL for details.

>Server: Msg 443, Level 16, State 2, Procedure ISOweek, Line 8
>Invalid use of 'SET COMMAND' within a function.
>
>Error 443 is explained in TSQL help as
>'Invalid use of '%s' within a function. ' which is great to know, but how do I get around that?
< snip >
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform