ʹÓÃSQLÓï¾äÆô¶¯SQL ServerÍâΧ×é¼þ·þÎñ
-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO
-- To enable the feature.
EXEC sp_configure 'CLR', 0
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GO
Ïà¹ØÎĵµ£º
set @sql = 'select * from OPENROWSET(''SQLOLEDB'',''SERVER='+@serverip+';uid=sa;pwd=sa;Database='+@databaseName+''',''SET FMTONLY OFF;set nocount on exec procName '''''+@yqid+''''''' ) as   ......
“Where” ÊÇÒ»¸öÔ¼ÊøÉùÃ÷£¬Ê¹ÓÃWhereÀ´Ô¼ÊøÀ´Ö®Êý¾Ý¿âµÄÊý¾Ý£¬WhereÊÇÔÚ½á¹û·µ»Ø֮ǰÆð×÷Óõģ¬ÇÒWhereÖв»ÄÜʹÓþۺϺ¯Êý¡£
“Having”ÊÇÒ»¸ö¹ýÂËÉùÃ÷£¬ÊÇÔÚ²éѯ·µ»Ø½á¹û¼¯ÒÔºó¶Ô²éѯ½á¹û½øÐеĹýÂ˲Ù×÷£¬ÔÚHavingÖпÉÒÔʹÓþۺϺ¯Êý¡£
ÔÚ˵Çø±ð֮ǰ£¬µÃÏȽéÉÜGROUP BYÕâ¸ö×Ӿ䣬¶øÔÚ˵GROUP×Ó¾äÇ° ......
11.3µ÷ÓųÌÐò/¼õÇḺÔØ
Èç¹ûÆÚÍû¼õÇáÊý¾Ý¿â·þÎñÆ÷ÕûÌåµÄCPU»òÕßI/O¸ºÔØ£¬¿Éͨ¹ýÒÔϲ½ÖèÈ·¶¨×ÊÔ´Ãܼ¯Ð͵ÄSQLÓï¾ä£º
1.Ñ¡ÔñÔÚÓ¦ÓóÌÐòµÄ´¦Àí¸ß·åÆÚ¼ì²â¡£
2.ÔÚÒÔÉÏÖÜÆÚÄÚ£¬ÊÕ¼¯²Ù×÷ϵͳ¼°Oracleͳ¼ÆÐÅÏ¢¡£ÐèÒªÊÕ¼¯µÄOracleͳ¼ÆÐÅÏ¢ÖÁÉÙ°üÀ¨ÎļþµÄI/O£¨Í¨¹ýÊÓͼV$FILESTAT£©£¬ÏµÍ³Í³¼ÆÐÅÏ¢£¨V$SYSSTAT£©£¬ÒÔ¼°SQLͳ¼ÆÐÅÏ¢£ ......
--------------------------------------------------------------------------
-- Author : htl258(Tony)
-- Date : 2010-04-23 20:33:15
-- Version:Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
-- Jul  ......
³£¼ûµÄSQL ServerÁ¬½Óʧ°Ü´íÎóÒÔ¼°½â¾ö·½·¨
A--S ......