存储过程存储过程存储过程存储过程8.248.248.248.24周三周三周三周三
--删除
create procedure sp_Delete
@name varchar(10),
@age int
as
begin
if exists(select * from dbo.Men where name=@name)
begin
delete from dbo.Men where name=@name
end
else
begin
print '输入有误,没有此条记录!'
end
end
exec sp_Delete 'lishanshan',25
exec sp_Delete 'xurongzhen',20 执行后在数据库里找不到此人的信息了.
-------------------------------------------------------------------------------------------------------
--往
表
关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf
中插入数据,如果存在相同姓名,更新,不存在就添加新数据
create procedure sp_InsertUpdate
@name varchar(10),
@age int
as
begin
if exists (select * from dbo.Men where name=@name)
begin
update dbo.Men set age=@age where name=@name
end
else
begin
insert into dbo.Men values(@name,@age)
end
end
exec sp_InsertUpdate 'lidonghan',20
-------------------------------------------------------------------------------------------------------
--更新
create procedure sp_Update
@name varchar(10),
@age int
as
begin
update dbo.Men set age=@age where name=@name
end
exec sp_Update 'lidonghan',26