34,588
社区成员
发帖
与我相关
我的任务
分享
--综合下
SELECT ISNULL(@STR1,'') <> ISNULL(@STR,'')
DECLARE @table TABLE(id int)
INSERT INTO @table
SELECT 1 UNION ALL
SELECT 2 UNION ALL
SELECT 3
SELECT * FROM @table WHERE id!=1
SELECT * FROM @table WHERE id<>1
/*
id
-----------
2
3
(2 row(s) affected)
id
-----------
2
3
(2 row(s) affected)
*/
<>