use 数据库名
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[存储过程名字]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[存储过程名字]
go
create PROCEDURE [dbo].[存储过程名字]
@q1 varchar(2),
@q2 char(2)
AS
Declare
@count int
Select @count = 0
select @count = count(* ) from A1 where 参数= q1
if @count > 0
Begin
insert into a2 values (@q2)
End
Begin Tran
if @count = 0
Begin
insert into a1 values (@q1)
insert into a2 values (@q2)