DECLARE @TT intGO
SELECT @TT = SUM(ENDTIME-STARTTIME) FROM U_MYTABLES WHERE PRODUCT = 'ARM'
AND STARTTIME > DATEDIFF(SS,'1970-1-1','2011-3-1')
AND ENDTIME < DATEDIFF(SS,'1970-1-1','2011-3-31')
error:Msg 137, Level 15, State 1, Line 1
Must declare the scalar variable "@TT".没有错误啊
DECLARE @TT int
SELECT @TT = SUM(ENDTIME-STARTTIME) FROM U_MYTABLES WHERE PRODUCT = 'ARM'
AND STARTTIME > DATEDIFF(SS,'1970-1-1','2011-3-1')
AND ENDTIME < DATEDIFF(SS,'1970-1-1','2011-3-31')不要GO
批处理语句DECLARE @TT intGO这就是声明了而且执行了
下面的语句单独执行
所以会报@TT没定义