22,209
社区成员
发帖
与我相关
我的任务
分享
DECLARE @table TABLE(id INT ,col VARCHAR(10))
INSERT INTO @table
SELECT 1,'a' UNION ALL
SELECT 2,NULL UNION ALL
SELECT 3,'b' UNION ALL
SELECT NULL,NULL
SELECT COUNT(*) FROM @table
/*4*/
SELECT COUNT(1) FROM @table
/*4*/
SELECT COUNT(id) FROM @table
/*3*/
SELECT COUNT(col) FROM @table
/*2*/