插入数据时,超过长度,不报错,还能插入
set ANSI_WARNINGS OFF DECLARE @TB TABLE ( C1 NVARCHAR(2) ) INSERT INTO @TB (C1) VALUES (N'34324' -- C1 - nvarchar(2) ) SELECT * FROM @TB --超过长度,不报错,还能插入
set ANSI_WARNINGS OFF DECLARE @TB TABLE ( C1 NVARCHAR(2) ) INSERT INTO @TB (C1) VALUES (N'34324' -- C1 - nvarchar(2) ) SELECT * FROM @TB --超过长度,不报错,还能插入