用sql语句修改数据表中字段 实现identity(100,1)的递增

create table common_info(name varchar(10),value int)insert into common_info values('msg_count', 100)你的sql应该这么写(用存储过程):create proc p_ins_alm_msg@msg_count int outasselect @msg_count = value from common_info where name = 'msg_count'update common_info set value = @msg_count+ 1 where name = 'msg_count' and value =

@msg_count if @@rowcount = 0 return -1000 insert into table1 (field0) values(@msg_count) return 0 go