这样可以满足你的要求:
在SQLSERVER中写过程
CREATE PROCEDURE MyPro
@Out int out
AS
begin
declare @RecCount int
Select @RecCount=Count(UserID) from UserDatum
Select @Out=@RecCount
Select * from UserDatum
end
GO
在DELPHI中调用:
procedure TForm1.Button1Click(Sender: TObject);
var
Tmp : integer;
begin
ADOStoredProc1.Open;
Tmp := ADOStoredProc1.Parameters.ParamByName('@Out').Value;
Self.Caption := inttostr(Tmp);
end;