摘要：--收缩日志USE DBNAME;GO-- Truncate the log by changing the database recovery model to SIMPLE.ALTER DATABASE DBNAMESET RECOVERY SIMPLE;GO-- Shrink the truncated log file to 1 MB.DBCC SHRINKFILE (DBNAME_Log, 1);GO-- Reset the database recovery model.ALTER DATABASE DBNAMESET RECOVERY FULL;GO 阅读全文

摘要：alter database [dbname] set offline with rollback immediatealter database [dbname] set online 阅读全文

摘要：--搜索指定数据在那个对象中存在.txt(所有表中模糊查询)CREATE PROC sp_ValueSearch@value sql_variant, --要搜索的数据@precision bit=1 --1=仅根据sql_variant中的数据类型查找对应类型的数据列.1,查询兼容的所有列,字符数据使用like匹配ASSET NOCOUNT ONIF @value IS NULL RETURN--数据类型处理SELECT xtype INTO #t FROM systypesWHERE name=SQL_VARIANT_PROPERTY(@value,N'BaseType') 阅读全文

摘要：exec sp_rename '数据库名.原字段名' ,'新字段名'eg:exec sp_rename 'org_photos.UpdateTime' ,'OperatingTime' 阅读全文

摘要：ALTER TABLE [表名]ADD CONSTRAINT 约束名 DEFAULT (0) FOR [字段名]example: ALTER TABLE [sms]ADD CONSTRAINT isout_default DEFAULT (0) FOR IsOut 阅读全文