22,210
社区成员
发帖
与我相关
我的任务
分享
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].A') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[A]
GO
CREATE PROCEDURE A
@A int,
@B VARCHAR(10),
@C Decimal(13,2)
AS
Select @A as A,@B as B,@C as C
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].B') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[B]
GO
CREATE PROCEDURE B
AS
EXEC A 100,'AAA',88.82
GO
EXEC B