摘要:
1.显示执行计划的详细步骤 SET SHOWPLAN_ALL ON; SET SHOWPLAN_ALL OFF; 2. 显示执行语句的IO成本,时间成本 SET STATISTICS IO ON SET STATISTICS IO OFF SET STATISTICS TIME ON SET STA 阅读全文
摘要:
1、说明:显示文章、提交人和最后回复时间 select a.title,a.username,b.adddate ,(select max(adddate) from table where table.title=a.title) adddate from table a 2、说明:两张关联表,删 阅读全文
摘要:
SELECT TOP 1000 [id], case when group_id>1 then 'vip' else '普通会员' end FROM [YaleBaoV2].[dbo].[ylb_users] SELECT TOP 1000 [id], case group_id when 1 th 阅读全文