Question

sql server 查询表中有多少条数据

Answer 1

SELECT COUNT(*) AS CNT FROM ITAB .

Answer 2

select count(*) from tableName where 1=1

Answer 3

select count（*） from table

Answer 4

select count(*) from tablename