有个表:t,有字段:name,birth,sex,state.
我想再填一个字段RID,用一标识唯一值,达到以下的效果,但又不用这个语句
select identity(int,1,1) as RID,* into t1 from t
怎么做啊?
我想再填一个字段RID,用一标识唯一值,达到以下的效果,但又不用这个语句
select identity(int,1,1) as RID,* into t1 from t
怎么做啊?
ADD RID identity(1,1) not null
select ROW_NUMBER() over ( order by name) as RID,* from t
哪来的column啊?