SQL从DB中取出多个字段赋值给多个变量/一个字段给单个变量赋值

 

DECLARE @FIRST_BEGIN    DATETIME
DECLARE @FIRST_END        DATETIME
DECLARE @SECOND_BEGIN    DATETIME
DECLARE @SECOND_END        DATETIME

SELECT    @FIRST_BEGIN = startDate_no1, @FIRST_END = endDate_no1,
        @SECOND_BEGIN = startDate_no2, @SECOND_END = endDate_no2
FROM tempTbl WHERE year= 2008 AND season= 3

PRINT @FIRST_BEGIN
PRINT @FIRST_END
PRINT @SECOND_BEGIN
PRINT @SECOND_END

 

----------------------------------------------------------------------------------------

给单个变量赋值

方法一:

DECLARE @FIRST_BEGIN    DATETIME

SELECT    @FIRST_BEGIN = startDate_no1
FROM tempTbl WHERE year= 2008 AND season= 3

 

方法二:

DECLARE @FIRST_BEGIN    DATETIME

SET @FIRST_BEGIN = (SELECT startDate_no1 FROM tempTbl WHERE year= 2008 AND season= 3)

注意,别忘了上面语句中的括号