询问一个sqlserver的写法

来源：百度知道 编辑：UC知道 时间：2024/06/29 21:26:50
现给出一个正常的表，要求每次向裱中插入数据，则会清空之前裱中的数据，保证表中始终只有一条记录存在，如何实现？

写触发器，当有数据插入时自动先删除数据再插入
create trigger tg_insert on A
for insert
as
begin
delete from A
insert into A(ID,name)select ID,name from inserted
end

CREATE PROCEDURE clare_student
@name char(10),@id int
as
begin
declare @count int
set @count=(select count(*) from student)
if @count>0
begin
delete from student
end
insert into student(NAME,ID) values(@name,@id)
end
go

delete from table1

insert into table1(field1,field2) values(value1,value2)

delete form table1;
insert into table1 values(?,?,?);

用触发器最好！