摘要:
SET NOCOUNT ON; INSERT INTO [TableName] ([Column1], [Column2]) VALUES (@value1, @value2); SELECT [Id] FROM [TableName] WHERE @@ROWCOUNT=1 AND [Id]=sco 阅读全文
摘要:
--设置简单恢复模式 ALTER DATABASE [DB_Data] SET RECOVERY SIMPLE; GO DBCC SHRINKFILE ([DB_Data_log], 1); GO --恢复为原模式 ALTER DATABASE [DB_Data] SET RECOVERY FULL 阅读全文