--delphi中
var
num:integer;
begin
With adoquery1 do
begin
close;
sql.clear;
sql.text:='select * from tablename';
open;
num:=recno;
end
showmessage(inttostr(num))
end
------------------------------------------------
--SQL中
declare @num int,
@sqls nvarchar(4000)
set @sqls='select @a=count(*) from tableName '
exec sp_executesql @sqls,N'@a int output',@num output
select @num