[产品需求][流水号重置] 如何操作? 数据库要操作哪个表还是方法里写死了.

[流水号重置] 如何操作? 数据库要操作哪个表还是方法里写死了. 这么弄也没成功.



declare @sql varchar(8000)
declare @name varchar(256)

set @name=''
set @sql='delete from '+@name +' dbcc checkident ('+@name+',reseed,0)'
print @sql
exec (@sql)

图片：001.png

各类方法都试过了.





为了美观 想从 001 开始.

DELETE FROM [H3Cloud].[dbo].[OT_Comment]
DELETE FROM [H3Cloud].[dbo].[I_carloan]
 
 
 
 DELETE FROM [H3Cloud].[dbo].[OT_InstanceContext]
 DELETE FROM [H3Cloud].[dbo].[OT_InstanceSimulation]
 DELETE FROM [H3Cloud].[dbo].[OT_InstanceSimulationDataItem]
 DELETE FROM [H3Cloud].[dbo].[OT_InstanceSimulationList]
 DELETE FROM [H3Cloud].[dbo].[OT_InstanceSimulationLog]
 
 
DELETE FROM [H3Cloud].[dbo].[OT_WorkItem]
DELETE FROM [H3Cloud].[dbo].[OT_WorkItemFinished]
DELETE FROM [H3Cloud].[dbo].[OT_WorkingTimeSpan]
DELETE FROM [H3Cloud].[dbo].[OT_WorkingDay]
DELETE FROM [H3Cloud].[dbo].[OT_WorkingCalendar]

自己解决了.分享下