别的不多说,直接上SQL:
修改时:
update [res].[dbo].[IP] set
ip1 = ID+1
output INSERTED.ID,
INSERTED.ip1
where Country = 'IANA'
插入时:
insert into [res].[dbo].[IP](ID, startip, endip)
output INSERTED.ID,INSERTED.startip,INSERTED.endip
values(234666,'12334', '34445')
删除时:
delete from [res].[dbo].[IP]
output deleted.ID, deleted.startip, deleted.endip
where ID = 234666