如何用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 out

    as

    select @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