206, Level 16, State 2, Line 3
--Operand type clash: date is incompatible with int
对于这种情形尝试做一个修正,...发生了下列错误:
DECLARE @a INT
DECLARE @b DATE
SET @a = CONVERT(INT,@b)
--Msg 529, Level 16, State 2, Line...257, Level 16, State 3, Line 3
--Implicit conversion from data type datetime to int is not allowed....下述转换将没有意义:
DECLARE @a INT
DECLARE @b DATETIME
SET CONVERT(DATETIME,@a) = @b
--Msg 156, Level 15, State...@b INT
SET @a = 1e13
SET @b = CONVERT(INT,@a)
Msg 232, Level
16, State 3, Line 4
Arithmetic