发布时间:2013-09-19 11:33:46来源:阅读(1894)
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
关键字: SQL
529
1630
1034
766
1291
1563
1396
1517
1462
807
9178
5753
5265
4887
4329
4042
3169
3092
3087
3046