求救！！！ - 编程论坛

菜鳥弎魛2007-12-25 12:29

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SaleTactic_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SaleTactic_Insert]
GO
CREATE PROCEDURE  [SaleTactic_Insert]
@province varchar(50) ,   -----区
@city  varcahr(50),    ---县
@school    varchar(50)    -----学校
AS
IF NOT EXISTS(SELECT * FROM SaleTactic WHERE
          province = @province  and  city  = @city   and school   = @school )
   BEGIN
     ---------这里写三个增加语句
     RETURN 1
   END
ELSE
     RETURN 0
GO

---------------------仿造这格式写个存储过程就行了