以Northwind数据库的Categories表为例，增加或修改的存储过程：
create PROCEDURE Categories_InsertOrUpdate@CategoryID int,@CategoryName nvarchar(15),@Description ntext,@Picture imageAS if not exists(select * from Categories where CategoryID=@CategoryID)beginINSERT INTO Categories(CategoryName,[Description],Picture)VALUES(@CategoryName,@Description,@Picture)endelsebeginUPDATE Categories SET CategoryName=@CategoryName,[Description] = @Description,Picture= @PictureWHERE CategoryID=@CategoryID end
View Code
测试：
exec Categories_InsertOrUpdate 9,'noodles', 'A kind of food',null
查询验证：
SELECT [CategoryID],[CategoryName],[Description],[Picture]FROM [Northwind].[dbo].[Categories]
View Code
再次执行验证：
exec Categories_InsertOrUpdate 9,'noodles', 'A kind of delicious food',null
查询验证截图：
如果觉得《增加或修改的存储过程》对你有帮助，请点赞、收藏，并留下你的观点哦！
