Sybase 15 tips
--select next_identity
select next_identity('dbo.TblHNWSwapSuitability')
--fixing identity gap and reset "next_identity" to 1
exec sp_chgattribute 'TblHNWSwapSuitability', 'identity_burn_max', 0,...
原创
2013-09-25 13:10:04 ·
89 阅读 ·
0 评论