-
添加一列自增:
-
alter table [dbo].[DeptRegTab]
add Id int IDENTITY(1,1) not null -
删除记录
-
delete from [dbo].[DeptRegTab]
-
where Id!=9
- 设置某记录值
-
update [dbo].[CheckCount]
set TotalCount=100
where DeptId='10001'
添加一列自增:
alter table [dbo].[DeptRegTab]
add Id int IDENTITY(1,1) not null
删除记录
delete from [dbo].[DeptRegTab]
where Id!=9
update [dbo].[CheckCount]
set TotalCount=100
where DeptId='10001'
转载于:https://www.cnblogs.com/YunGy/p/3319676.html