编辑数据库的自增字段（自动编号字段）

Posted on 2009/07/01 by 阿飞

Reply

SET IDENTITY_INSERT [TABLE1] ON
UPDATE [TABLE1] SET ID = B WHERE ID = A
SET IDENTITY_INSERT [TABLE1] OFF

SqlServer清理日志的方法

Posted on 2009/06/30 by 阿飞

Reply

SqlServer中用于删除日志和备份数据库的两个存储过程
Continue reading →