求一个查询语句

Question

declare @exp as int
select @exp=count(*) from tablename
select field1,field2,@exp count from tablename

Answer 1

执行后,判断@@rowcount就行了.或者用:
select count(*)=行数 from(
select field1,field2 from tableName
) a

Answer 2

select * from
  (select field1,field2 from tableName) cross join 
  (select count(*) AS 记录总数 from tableName)

Answer 3

select * from
  (select field1,field2 from tableName) A 
  cross join (select count(*) AS 记录总数 from tableName) B

Answer 4

select field1,field2,(select count(*) from tableName) as 行数
from tablename

Answer 5

现在不想用count(*)，还有没有办法？

Answer 6

select field1,field2 from tableName
print @@rowcount

Answer 7

select field1,field2 from tableName
print @@rowcount

Answer 8

select count(*) from (select field1,field2 from tableName) tem

Answer 9

select count(*) from (select field1,field2 from tableName) tem

Answer 10

执行后,判断@@rowcount就行了.或者用:
select count(*)=行数 from(
select field1,field2 from tableName
) a

Answer 11

select field1,field2,(select sum(1) from tableName) as 行数
from tablename

Answer 12

方法1:
select field1,field2 from tableNameselect 行数=@@rowcount方法2:
select 行数=sum(1) from(select field1,field2 from tableName) a方法3:
select 行数=count(*) from(select field1,field2 from tableName) a

Answer 13

select field1,field2,count(*) from tableName

Answer 14

select field1,field2,(select sum(1) from tablename) 记录数 from tableName