摘要:
USE BKMGPS; --指定要生成数据字典的数据库GOSELECT 表名 = CASE WHEN a.colorder = 1 THEN d.name ELSE '' END , 表说明 = CASE WHEN a.colorder = 1 THEN ISNULL(f.value, '') EL 阅读全文
摘要:
select 'drop table '+name+';' from sys.tables where name like 'B111%' select 'BKM'+SystemNo from b.[dbo].[b] where 'BKM'+SystemNo not in (select name 阅读全文
摘要:
using System; using System.Collections.Generic; using System.Linq; using System.Web; using TalentCloud.Base.Utils; using System.IO; using System.Text; 阅读全文
摘要:
SQL优化方法: 1、查看连接对象 SELECT TOP 10[session_id],[request_id],[start_time] AS '开始时间',[status] AS '状态',[command] AS '命令',dest.[text] AS 'sql语句', DB_NAME([da 阅读全文