摘要：@echo on rem write to log set filename=deletefile.log echo Delete Expired Log Files >>%filename% echo Start >>%filename% echo (%date% %time%) >>%filen 阅读全文

摘要：迁移tempdb： 第一步： USE master; GO ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'E:\SQLDB\tempdb.mdf'); GO ALTER DATABASE tempdb MODIFY FI 阅读全文

摘要：USE [V33SelfDB] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[x_timer_log]( [id] [int] IDENTITY(1,1) 阅读全文