sql server: SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[A_GET_GOOD_NUM]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[A_GET_GOOD_NUM] GO CREATE PROCEDURE A_GET_GOOD_NUM ( @Store_ID VARCHAR(10), @GOODS_ID NUMERIC, @TIMES VARCHAR(20), @GOODS_NUM FLOAT OUTPUT ) AS --填入语句 set @goods_num=0 select @goods_num=sum(NUM) from mytable where store_id like @store_id and goods_id=@goods_id and times like @timesgo --调用实例 declare @goods_num float exec a_get_good_num '01',1231,'040301',@goods_numGO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[A_GET_GOOD_NUM]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[A_GET_GOOD_NUM]
GO
CREATE PROCEDURE A_GET_GOOD_NUM
(
@Store_ID VARCHAR(10),
@GOODS_ID NUMERIC,
@TIMES VARCHAR(20),
@GOODS_NUM FLOAT OUTPUT
)
AS
--填入语句
set @goods_num=0
select @goods_num=sum(NUM) from mytable where store_id like @store_id and goods_id=@goods_id and times like @timesgo
--调用实例
declare @goods_num float
exec a_get_good_num '01',1231,'040301',@goods_numGO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
2. ADO的用ADOStoreProc存储过程控件, 在属性里Connection选连接数据库的Connection1 ,ProcedureName先为你的存储过程名.