解惑SQL Server中LIKE使用变量类型不同输出结果不一致
复制CREATETABLE TEST
(
ID INT IDENTITY(1,1),
NAMEVARCHAR(32)
)
INSERTINTO dbo.test
SELECTabc32;
INSERTINTO dbo.test
SELECTabd32;
INSERTINTO dbo.test
SELECTabe32 ;
DECLARE @nameVARCHAR(32);
SET @name=ab%;
SELECT * FROM TEST WHERENAMELIKE @name;
DECLARE @name1 CHAR(32);
SET @name1=ab%;
SELECT * FROM dbo.TEST WHERENAMELIKE @name1;
1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.
THE END
