SQL Server ÓÅ»¯SELECTÓï¾ä·½·¨
±¾ÎÄת×Ô£ºhttp://industry.ccidnet.com/art/1106/20070514/1080519_1.html
±¾ÎÄÊÇSQL Server SQLÓï¾äÓÅ»¯ÏµÁÐÎÄÕµĵÚһƪ¡£¸ÃϵÁÐÎÄÕÂÃèÊöÁËÔÚMicosoft’s SQLServer2000¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳÖÐÓÅ»¯SELECTÓï¾äµÄ»ù±¾¼¼ÇÉ£¬ÎÒÃÇÌÖÂ۵ļ¼ÇÉ¿ÉÔÚMicrosoft's SQL Enterprise Manager»ò Microsoft SQL Query Analyzer£¨²éѯ·ÖÎöÆ÷£©ÌṩµÄMicrosoftͼÐÎÓû§½çÃæÊ¹Óá£
³ýµ÷ÓÅ·½·¨Í⣬ÎÒÃǸøÄãչʾÁË×î¼Ñʵ¼ù£¬Äã¿ÉÓ¦Óõ½ÄãµÄSQLÓï¾äÖÐÒÔÌá¸ßÐÔÄÜ£¨ËùÓеÄÀý×ÓºÍÓï·¨¶¼ÒÑÔÚMicrosoft SQL Server 2000ÖÐÑéÖ¤£©¡£
ÔĶÁ¸ÃϵÁÐÎÄÕºó£¬ÄãÓ¦¸Ã¶ÔMicrosoft ¹¤¾ß°üÖÐÌṩµÄ²éѯÓÅ»¯¹¤¾ßºÍ¼¼ÇÉÓÐÒ»¸ö»ù±¾µÄÁ˽⣬ÎÒÃǽ«Ìṩ°üº¬¸÷ÖÖ¸÷ÑùµÄÒÔÌá¸ßÐÔÄܺͼÓËÙÊý¾Ý¶ÁÈ¡²Ù×÷µÄ²éѯ¼¼ÇÉ¡£
MicrosoftÌṩÁËÈýÖÖµ÷ÓŲéѯµÄÖ÷ÒªµÄ·½·¨£º
ʹÓÃSET STATISTICS IO ¼ì²é²éѯËù²úÉúµÄ¶ÁºÍд£»
ʹÓÃSET STATISTICS TIME¼ì²é²éѯµÄÔËÐÐʱ¼ä£»
ʹÓÃSET SHOWPLAN ·ÖÎö²éѯµÄ²éѯ¼Æ»® ¡£
SET STATISTICS IO
ÃüÁîSET STATISTICS IO ON Ç¿ÖÆSQL Server ±¨¸æÖ´ÐÐÊÂÎñʱI/OµÄʵ¼Ê»î¶¯¡£Ëü²»ÄÜÓëSET NOEXEC ON Ñ¡ÏîÅä¶ÔʹÓã¬ÒòΪËü½ö½ö¶Ô¼à²âʵ¼ÊÖ´ÐÐÃüÁîµÄI/O»î¶¯ÓÐÒâÒå¡£Ò»µ©Õâ¸öÑ¡Ïî±»´ò¿ª£¬Ã¿¸ö²éѯ²úÉú°üÀ¨I/Oͳ¼ÆÐÅÏ¢µÄ¶îÍâÊä³ö¡£ÎªÁ˹رÕÕâ¸öÑ¡ÏִÐÐSET STATISTICS IO OFF¡£
×¢£ºÕâЩÃüÁîÒ²ÄÜÔÚ Sybase Adaptive ServerÖÐÔËÐУ¬ËäÈ»½á¹û¼¯¿ÉÄÜ¿´ÆðÀ´Óе㲻ͬ¡£
ÀýÈ磬ÏÂÃæÊÇÔÚNorthwind Êý¾Ý¿âÖжÔÓÚemployees±íÉϵÄÒ»¸öÐÐͳ¼ÆµÄ¼òµ¥²éѯ½Å±¾¶ø»ñµÃµÄI/Oͳ¼ÆÐÅÏ¢:
SET STATISTICS IO ON
GO
SELECT COUNT(*) from employees
GO
SET STATISTICS IO OFF
GO
Results:
---------------
2977
Table ‘Employees’ . Scan count 1,
logical read 53, physical reads 0, readahead reads 0.
Õâ¸öɨÃèͳ¼Æ¸æËßÎÒÃÇɨÃèÖ´ÐеÄÊýÁ¿£¬Âß¼¶ÁÏÔʾµÄÊÇ´Ó»º´æÖжÁ³öÀ´µÄÒ³ÃæµÄÊýÁ¿£¬ÎïÀí¶ÁÏÔʾµÄÊÇ´Ó´ÅÅÌÖжÁµÄÒ³ÃæµÄÊýÁ¿£¬Read-ahead ¶ÁÏÔʾÁË·ÅÖÃÔÚ»º´æÖÐÓÃÓÚ½«À´¶Á²Ù×÷µÄÒ³ÃæÊýÁ¿¡£
´ËÍ⣬ÎÒÃÇÖ´ÐÐÒ»¸öϵͳ´æ´¢¹ý³Ì»ñµÃ±í´óСµÄͳ¼ÆÐÅÏ¢ÒÔ¹©ÎÒÃÇ·ÖÎö£º
sp_spaceused employees
Results:
name rows reserved data index_size unused
-------------- -------- --------- -------
Employees 2977 2008KB 1504KB 4
Ïà¹ØÎĵµ£º
select * from ((select bill.id billId,bach.riskRate risk,bach.assureRate assure from AcptBillInfo bill,AcptBach bach where bill.acptBatchId=bach.id and bill.rgctId=? )abach left outer join AcptSignMoney sig on abach.billId = sig.billId) ......
SQL Server£º´æ´¢Í¼ÏñºÍBLOBÎļþ(Ò»)
×÷ÕߣºØýÃû ÎÄÕÂÀ´Ô´£ºOnegreen.Net ä¯ÀÀ´ÎÊý£º2559 ¸üÐÂʱ¼ä£º2008-5-25 23:16:09
¡¡¡¡Ê²Ã´ÊÇBLOB
¡¡¡¡Ê×ÏÈ£¬ÎÒÃÇÀ´±È½ÏÁ½ÖÖÎļþÀàÐÍASCIIºÍ¶þ½øÖÆ¡£´æ´¢ÔÚSQL ServerÖеĴ󲿷ÖÊý¾ÝÖµ¶¼ÊÇÓÉASCII(ÃÀ¹úÐÅÏ¢½»»»±ê×¼´úÂë)×Ö·û×é³É¡£¼òµ¥ËµÀ´£¬ASCII×Ö·û¾ÍÊÇÄܹ»ÔÚ¼ ......
inner join(µÈÖµÁ¬½Ó) Ö»·µ»ØÁ½¸ö±íÖÐÁª½á×Ö¶ÎÏàµÈµÄÐÐ
left join(×óÁª½Ó) ·µ»Ø°üÀ¨×ó±íÖеÄËùÓмǼºÍÓÒ±íÖÐÁª½á×Ö¶ÎÏàµÈµÄ¼Ç¼
right join(ÓÒÁª½Ó) ·µ»Ø°üÀ¨ÓÒ±íÖеÄËùÓмǼºÍ×ó±íÖÐÁª½á×Ö¶ÎÏàµÈµÄ¼Ç¼
INNER JOIN Óï·¨£º
INNER JOIN Á¬½ÓÁ½¸öÊý¾Ý±íµÄÓ÷¨£º
SELECT * from ±í1 INNER JOIN ±í2 ON ±í1.×ֶκÅ=±í2 ......
²Ù×÷Êý¾Ý¿â½á¹¹µÄ³£ÓÃSql
ÏÂÃæÊÇSql Server ºÍ Access ²Ù×÷Êý¾Ý¿â½á¹¹µÄ³£ÓÃSql£¬ÄÚÈÝÓɺ£ÍÞÕûÀí£¬²»ÕýÈ·Óë²»ÍêÕûÖ®´¦»¹ÇëÌá³ö£¬Ð»Ð»¡£
н¨±í£º
create table [±íÃû]
(
[×Ô¶¯±àºÅ×Ö¶Î] int IDENTITY (1,1) PRIMARY KEY ,
[×Ö¶Î1] nVarChar(50) default 'ĬÈÏÖµ' null ,
[×Ö¶Î2] ntext null ,
[×Ö¶Î3] dateti ......
¹¦ÄÜ£ºÐ¡Ð´½ð¶îת»»³É´óд
²ÎÊý£º@LowerMoney Сд½ð¶î ¼ÓÉÏСÊýµã×¿ÉÒÔ±£Áô38λ
Êä³ö£º´óд½ð¶î
¼ò½é£ºSQL°æ Сд½ð¶îת»»³É´óд½ð¶î£¨×î¶à¿ÉÒÔ¾«È·µ½Ð¡ÊýµãËÄ룩
×¢£º Decimal Êý¾ÝÀàÐÍ×î¶à¿É´æ´¢ 38 ¸öÊý×Ö
×ªÔØ£ºÇë±£ÁôÒÔÉÏÐÅÏ¢,лл£¡£¡£¡
********************************* ......