[MS FAQ] ��ϸ��T-SQL��ѯִ��Ϣ

Article View: cn.bbs.comp.database

Article #808

Back to cn.bbs.comp.database Previous Next

#808

From: Galaxy��VOLUNTEERS��Database
Date: Tue, 11 Nov 2008 12:52

51 lines
3089 bytes

FAQ: �����ϸ��T-SQL��ѯִ����Ϣ

Q������֪��ĳ����ѯִ���˾�����Щ��������ϸ��Ϣ��������ô����

A��
����Գ���ʹ�ò�ͬ��Showplan SET ѡ���Щѡ�����Ϊ����ʾ��ѯִ�мƻ���

��ע�⣬SHOWPLAN_XML��SHOWPLAN_ALL �� SHOWPLAN_TEXT SET ѡ��Ϊÿ���������
һ���м���STATISTICS XML �� STATISTICS PROFILE SET ѡ��Ϊ�����е�ÿ��ѡ����
��һ���м���

������STATISTICS PROFILEΪ��
STATISTICS PROFILE Ϊ ON ʱ��ִ�еĸ�����ѯ�������䳣���������һ������
�����ʾ��ѯִ�е������ļ���
���ӽ����ѯ�� SHOWPLAN_ALL ���Լ����������ɵ�ʵ������������ִ�е�
����

��Ȼ��ִ�и�ѡ�����Ҫӵ�ж԰� Transact-SQL ������õĶ����������ݿ��� 
SHOWPLAN Ȩ�ޡ�

�ٸ����ӣ�SQL Server����INSERT��ѯ�������µ��﷨��������һ����ѯ�в�������
����1000������¼���������֪�����﷨�봫ͳINSERT�﷨��ִ�о����кβ�����
��ʹ�����´��룺
SET STATISTICS PROFILE ON
INSERT INTO [TestDB1].[dbo].[TestTable1]
           ([col1]
           ,[col2])
     VALUES
           (1,11),
           (2,22)
INSERT INTO [TestDB1].[dbo].[TestTable1]
           ([col1]
           ,[col2])
     VALUES
           (1,11)
INSERT INTO [TestDB1].[dbo].[TestTable1]
           ([col1]
           ,[col2])
     VALUES
           (2,22)
SET STATISTICS PROFILE OFF
�ӽ���и����﷨��ִ��ԭ���봫ͳINSERT�﷨��ͬ��

��http://msdn.microsoft.com/en-us/library/ms180765.aspx��http://msdn.microsof
t.com/en-us/library/ms188752.aspx����Ի�ø�������Ϣ�� 
--
Welcome to Database Board
��ӭ������ݿ��
http://bbs.sjtu.edu.cn/bbsdoc?board=database

[m[1;37m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.30][m

Technical Details

Message-ID: <4d1N5U$b4l@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.pigpark.net!news.shec6.edu.cn!SJTU

Show Full Headers

Complete Article Headers

X-Google-Thread: 101948,3651820e4a7a23e1,start
X-Google-Attributes: gid101948,domainid0,public,usenet
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.pigpark.net!news.shec6.edu.cn!SJTU
From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS��Database)
Newsgroups: cn.bbs.comp.database
Subject: [MS FAQ] �����ϸ��T-SQL��ѯִ����Ϣ
Date: 11 Nov 2008 12:52:45 GMT
Organization: ��ˮ˼Դ
Message-ID: <4d1N5U$b4l@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1226407950.A

Article View: cn.bbs.comp.database

[MS FAQ] �����ϸ��T-SQL��ѯִ����Ϣ

[MS FAQ] ��ϸ��T-SQL��ѯִ��Ϣ