|
|
|||||||
| 建站交流 讨论网站建设的基本方法、技巧、空间问题讨论、域名交流、 资源分享、技术交流，站长们经常进来看看噢! |
 |
|
|
Thread Tools | Display Modes |
|
#1
IP: 117.95.89.4
2010-07-03, 06:36 PM
|
|||
|
|||
用sql语句更改自动编号的字段重新重'1'开始编号
tableName(id,clcode,cloth) id字段为identity(int,1,1) 重建id
select * into #aa from tableName truncate table tableName dbcc checkident(tableName,reseed,0) set IDENTITY_INSERT ON insert tableName(clcode,clname) select clcode,clname from #aa //注意不能选择id列 drop table #aa 
|
|
| Currently Active Users Viewing This Thread: 2 (0 members and 2 guests) | |
|
|
Linear Mode
