--返回自动生成的标识ID
INSERT INTO jobs (job_desc,min_lvl,max_lvl) VALUES ('Accountant',12,125)
SELECT @@IDENTITY AS 'Identity'
--按指定排序生成序号
select row_number() over(order by wordid) xh,wordid,WordName from Words
关联更新:
update TA set name=b.name, remark=b.remark from TA a inner join TB b on a.id = b.id
或者
update TA set name=b.name, remark=b.remark from TA a, TB b where a.id = b.id
注意不要在被更新表的的栏位前面加别名前缀,否则语法静态检查没问题,实际执行会报错。