sql server增量查询 [英] sql server increment query

问题描述

我有一个变量@var =''AA0001''
现在我想增加这个变量，例如AAA0002，AA0003 ...... AA0010..AA0011 ..
AA1100
有人可以帮我吗?
plzzzzz

解决方案

只是google并找到 ^ ].

您可以尝试这样..
在sql中选择要修改的表.然后首先删除主键.它们的类型为

AA0001

然后保存.保存后再次修改并设置为主键，IsIdentity设置为yes.

i have one variable @var=''AA0001''
now i want to increment this variable like AA0002,AA0003......AA0010..AA0011..
AA1100
so can any one help me???
plzzzzz

解决方案

just google and find this[^].

hi u can try like this..
in sql select table to modify.then first u remove primary key.they type

AA0001

then save..after saving once again modify and set as primary key and IsIdentity set to yes..hope it works..if it is ur solution..accept it..

这篇关于sql server增量查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！