用SQL语句判断数据库中的记录是否存在

最新推荐文章于 2024-02-18 20:17:23 发布

wange001

最新推荐文章于 2024-02-18 20:17:23 发布

阅读量2.2k

点赞数

分类专栏： .NET笔记文章标签：数据库 sql insert output null

本文链接：https://blog.csdn.net/wange001/article/details/625121

版权

.NET笔记专栏收录该内容

6 篇文章 0 订阅

订阅专栏

ALTER PROCEDURE wg_News_InsertCategory

@Name varchar(50),
@Description varchar(250),
@ImageUrl varchar(250),
@CategoryID int OUTPUT
AS
DECLARE @CurrID int

-- see if the category already exists

SELECT @CurrID = CategoryID
FROM News_Categories
WHERE Name = @Name

-- if not, add it

IF @CurrID IS NULL
BEGIN
INSERT INTO News_Categories
  (Name, Description, ImageUrl)
  VALUES (@Name, @Description, @ImageUrl)
SET @CategoryID = @@IDENTITY
IF @@ERROR > 0
  BEGIN
  RAISERROR ('Insert of Category failed', 16, 1)
  RETURN 99
  END
END
ELSE
BEGIN
SET @CategoryID = -1
END