我希望使用SELECT语句创建一个表,并添加一列行号。因此,我想写类似以下的代码:
create table schema.table_w_rownumbers as
select
identity(1, 1) as nrum,
foo.*
from schema.initial_table as foo;