12 2019 档案
摘要:/*收缩数据库日志大小*/ --数据库名称为 PTS2_NULL,请自行替换USE master GO ALTER DATABASE PTS2_NULL SET RECOVERY SIMPLE WITH NO_WAIT GO ALTER DATABASE PTS2_NULL SET RECOVERY
阅读全文
posted @ 2019-12-07 14:13
帅被盗版
摘要:--根据关键字查找包含此关键字的存储过程名SELECT DISTINCT t1.name FROM SYSOBJECTS t1, SYSCOMMENTS t2WHERE t1.id = t2.idAND t1.xtype = 'P'AND t2.text LIKE '%关键字%'
阅读全文
posted @ 2019-12-07 14:11
帅被盗版
摘要:CREATE TABLE #TEST(A VARCHAR(10) NULL,B VARCHAR(MAX) NULL) INSERT INTO #TESTSELECT 'A','A001'UNION ALLSELECT 'A','A002'UNION ALLSELECT 'A','A003'UNION
阅读全文
posted @ 2019-12-07 11:27
帅被盗版

浙公网安备 33010602011771号