DECLARE @StartDate smalldatetime
SET @StartDate = '4/1/2005'DECLARE @EndDate smalldatetime
SET @EndDate = '4/1/2006'DECLARE @VacationEx TABLE
(
VendorID int,
Durcation int,
ReasonID int
);SELECT
VendorID,
DATEDIFF(day,
CASE WHEN StartDate > @StartDate THEN StartDate ELSE @StartDate END,
CASE WHEN EndDate < @EndDate THEN EndDate ELSE @EndDate END
)
AS Duration,
ReasonID
INTO @VacationEx -----系统提示这里有错
FROM
Vacation执行后错误提示为:
Msg 170, Level 15, State 1, Line 22
Line 22: Incorrect syntax near '@VacationEx'.
多谢帮忙!
SET @StartDate = '4/1/2005'DECLARE @EndDate smalldatetime
SET @EndDate = '4/1/2006'DECLARE @VacationEx TABLE
(
VendorID int,
Durcation int,
ReasonID int
);SELECT
VendorID,
DATEDIFF(day,
CASE WHEN StartDate > @StartDate THEN StartDate ELSE @StartDate END,
CASE WHEN EndDate < @EndDate THEN EndDate ELSE @EndDate END
)
AS Duration,
ReasonID
INTO @VacationEx -----系统提示这里有错
FROM
Vacation执行后错误提示为:
Msg 170, Level 15, State 1, Line 22
Line 22: Incorrect syntax near '@VacationEx'.
多谢帮忙!
SELECT
VendorID,
DATEDIFF(day,
CASE WHEN StartDate > @StartDate THEN StartDate ELSE @StartDate END,
CASE WHEN EndDate < @EndDate THEN EndDate ELSE @EndDate END
)
AS Duration,
ReasonID
FROM
Vacation