Products_DS

最新推荐文章于 2024-06-21 18:47:59 发布

原创最新推荐文章于 2024-06-21 18:47:59 发布 · 411 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#delete #go #output #脚本

USE [XiaoBo]
GO
/****** 对象: StoredProcedure [dbo].[Products_DS] 脚本日期: 07/06/2007 09:51:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[Products_DS]
(
@Pid int ,
@status int ,
    @ActType INT ,
    @RetValue INT output
)
AS
DECLARE @ID INT
DECLARE @ERROR INT
DECLARE @ROWCOUNT INT

IF( @ActType = 2 )
BEGIN
  -- DELETE
  DELETE
      FROM   [Products]
      WHERE
     [Pid] = @Pid


  SELECT @ERROR = @@ERROR, @ID = @@IDENTITY, @ROWCOUNT = @@ROWCOUNT
  IF( @ROWCOUNT = 1 )
             Set @RetValue=-1
  ELSE
            Set @RetValue=1

END
ELSE IF( @ActType = 3 )
BEGIN
  -- DELETE

  Update [Products]
       SET    [status] = @status
       WHERE
     [Pid] = @Pid
     SELECT @ERROR = @@ERROR, @ID = @@IDENTITY, @ROWCOUNT = @@ROWCOUNT
  IF( @ROWCOUNT = 1 )
   Set @RetValue=-1
  ELSE
   Set @RetValue=1


END
ELSE IF (@ActType = 4)
BEGIN
    -- SELECT
    SELECT *
        FROM [Products] (NOLOCK)
      WHERE
     [Pid] = @Pid
END
ELSE
BEGIN
  RAISERROR( 'The ActionType value should be between 2 and 4. The value of %d was not within this range', 16, 1, @ActType )
  Set @RetValue=-1
END