Posts Tagged ‘Sql Server’

编辑数据库的自增字段(自动编号字段)

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

Read the rest of this entry »

SqlServer清理日志的方法

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

Read the rest of this entry »