本文展示了一个使用SQL从[AATP2].[dbo].[TS_User]表中进行数据选择的示例，并通过左连接的方式引入了类型信息。同时启用了SQL Server的性能分析工具，包括统计配置文件、I/O统计信息及执行时间统计。
SET STATISTICS PROFILE ON
SET STATISTICS IO ON
SET STATISTICS TIME ON
/*--你的SQL脚本开始*/
SELECT *
FROM [AATP2].[dbo].[TS_User]
left join ( select top 5 f_id,F_Name from [dbo].[TS_UserType] ) as ttt
on [F_UserTypeId]=ttt.F_id
/*你的SQL脚本结束*/
SET STATISTICS PROFILE OFF SET STATISTICS IO OFF SET STATISTICS TIME OFF
SET STATISTICS IO ON
SET STATISTICS TIME ON
/*--你的SQL脚本开始*/
SELECT *
FROM [AATP2].[dbo].[TS_User]
left join ( select top 5 f_id,F_Name from [dbo].[TS_UserType] ) as ttt
on [F_UserTypeId]=ttt.F_id
/*你的SQL脚本结束*/
SET STATISTICS PROFILE OFF SET STATISTICS IO OFF SET STATISTICS TIME OFF
扫一扫
403
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
