将表的记录个数存入到变量中: Declare @max int select @max=count(*) from TBLPRICELISTGROUPITEM where BUS_CODE='11000' print @max