以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
查询验证截图:
如果觉得《增加或修改的存储过程》对你有帮助,请点赞、收藏,并留下你的观点哦!