Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ʹÓÃ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


Ïà¹ØÎĵµ£º

SQL ÖÐÈçºÎ·µ»Ø´æ´¢¹ý³ÌÖеĽá¹û¼¯

set @sql = 'select    *   from   OPENROWSET(''SQLOLEDB'',''SERVER='+@serverip+';uid=sa;pwd=sa;Database='+@databaseName+''',''SET   FMTONLY   OFF;set   nocount   on exec   procName '''''+@yqid+''''''' ) as   ......

SQLÖÐWhereÓëHavingµÄÇø±ð

“Where” ÊÇÒ»¸öÔ¼ÊøÉùÃ÷£¬Ê¹ÓÃWhereÀ´Ô¼ÊøÀ´Ö®Êý¾Ý¿âµÄÊý¾Ý£¬WhereÊÇÔÚ½á¹û·µ»Ø֮ǰÆð×÷Óõģ¬ÇÒWhereÖв»ÄÜʹÓþۺϺ¯Êý¡£
“Having”ÊÇÒ»¸ö¹ýÂËÉùÃ÷£¬ÊÇÔÚ²éѯ·µ»Ø½á¹û¼¯ÒÔºó¶Ô²éѯ½á¹û½øÐеĹýÂ˲Ù×÷£¬ÔÚHavingÖпÉÒÔʹÓþۺϺ¯Êý¡£
ÔÚ˵Çø±ð֮ǰ£¬µÃÏȽéÉÜGROUP BYÕâ¸ö×Ӿ䣬¶øÔÚ˵GROUP×Ó¾äÇ° ......

11 SQLµ÷ÓŸÅÊö

11.3µ÷ÓųÌÐò/¼õÇḺÔØ
Èç¹ûÆÚÍû¼õÇáÊý¾Ý¿â·þÎñÆ÷ÕûÌåµÄCPU»òÕßI/O¸ºÔØ£¬¿Éͨ¹ýÒÔϲ½ÖèÈ·¶¨×ÊÔ´Ãܼ¯Ð͵ÄSQLÓï¾ä£º
1.Ñ¡ÔñÔÚÓ¦ÓóÌÐòµÄ´¦Àí¸ß·åÆÚ¼ì²â¡£
2.ÔÚÒÔÉÏÖÜÆÚÄÚ£¬ÊÕ¼¯²Ù×÷ϵͳ¼°Oracleͳ¼ÆÐÅÏ¢¡£ÐèÒªÊÕ¼¯µÄOracleͳ¼ÆÐÅÏ¢ÖÁÉÙ°üÀ¨ÎļþµÄI/O£¨Í¨¹ýÊÓͼV$FILESTAT£©£¬ÏµÍ³Í³¼ÆÐÅÏ¢£¨V$SYSSTAT£©£¬ÒÔ¼°SQLͳ¼ÆÐÅÏ¢£ ......

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Á¬½Óʧ°Ü´íÎóÒÔ¼°½â¾ö·½·¨¡¿

                                         ³£¼ûµÄSQL ServerÁ¬½Óʧ°Ü´íÎóÒÔ¼°½â¾ö·½·¨
 
A--S ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ