SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO/*-创建存储过程-*/
ALTER PROCEDURE GetVIPsg
@VIPID int, --VIPID
@Community nvarchar(20)=null OUTPUT,
@StateOfHealth nvarchar(20)=null OUTPUT,
@OftenAppliesDrugs nvarchar(20)=null OUTPUT,
@VIPName nvarchar(20)=null OUTPUT,
@Address nvarchar(20)=null OUTPUT,
@Telephone nvarchar(20)=null OUTPUT,
@ret int=null OUTPUT
as
BEGIN TRANSACTION
SELECT @Community=Community,@StateOfHealth=StateOfHealth,@OftenAppliesDrugs=OftenAppliesDrugs FROM VIPg WHERE VIPID=@VIPID SELECT @VIPName=VIPName,@Address=Address,@Telephone=Telephone FROM VIPs WHERE VIPID=@VIPID
IF @@ERROR<>0
BEGIN
ROLLBACK TRANSACTION
SELECT @ret=1
END
ELSE
BEGIN
COMMIT TRANSACTION
SELECT @ret=0
ENDGO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
此存储过程对不对呀·我要返回的
@Community nvarchar(20)=null OUTPUT,
@StateOfHealth nvarchar(20)=null OUTPUT,
@OftenAppliesDrugs nvarchar(20)=null OUTPUT,
@VIPName nvarchar(20)=null OUTPUT,
@Address nvarchar(20)=null OUTPUT,
@Telephone nvarchar(20)=null OUTPUT,
@ret int=null OUTPUT 可以得到吗· 然后就是·我要把这些返回的东西存到DataGridView里显示出来要怎么写才对··
初学者·很多地方不懂呀
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货