Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
Syntax error or access violation;-5015 POS(155) Missing keyword:FETCH,CLOSE,WHILE,UPDATE,TRY,SUBTRANS,STOP,SET,SELECT
CREATE FUNCTION ISOweek (@DATE DATE)
RETURNS int
AS
VAR @ISOweek int;
BEGIN
SET @ISOweek= DAYOFWEEK(@DATE)+1 - DAYOFWEEK(CHR(YEAR(@DATE))+'0104');
---- Error -------------------------------
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
Syntax error or access violation;-3005 POS(1) Invalid SQL statement
IF @ISOweek=0 THEN SET @ISOweek=ISOweek(CHR(YEAR(@DATE)-1)+'12'+ CHR(24+ DAY(@DATE),2))+ 1;
---- Error -------------------------------
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
Syntax error or access violation;-3005 POS(1) Invalid SQL statement
IF (MONTH(@DATE)=12) AND ((DAY(@DATE) - DAYOFWEEK(@DATE))>= 28) THEN SET @ISOweek=1;
RETURN @ISOweek;
END
_________________________________________________________________
与联机的朋友进行交流，请使用 MSN Messenger: http://messenger.msn.com/cn
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
