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

»ñÈ¡SQL ServerµÄһЩϵͳÐÅÏ¢

 --@@CPU_BUSY»ñÈ¡cpu¹¤×÷ʱ¼ä
select @@CPU_BUSY AS 'CPU ms',GETDATE() AS 'TIMES'
--»ñÈ¡´ÅÅ̶Áд´ÎÊý
SELECT @@TOTAL_READ AS 'Reads',@@TOTAL_WRITE AS 'Writes', GETDATE() AS 'As of'
--»ñÈ¡SQl·þÎñÆ÷Ãû
SELECT HOST_NAME()
--»ñµÃÊý¾Ý¿â±íʾºÅ
USE master
SELECT name,DB_ID(name) AS DB_ID from sysdatabases
--ÅжÏÓû§ÊÇ·ñ¾ßÓзÃÎÊÊý¾Ý¿âȨÏÞ
SELECT HAS_DBACCESS('master')
--ÏÔʾ±íÖÐÁ㤶ÈÐÅÏ¢
SELECT COL_LENGTH('student','stuEnglish')
--»ñÈ¡Á¬½Ó»òÊÔͼÁ¬½ÓµÄ´ÎÊý
SELECT GETDATE() AS 'Today Date and Time',@@CONNECTIONS AS 'Login Attemps'
--»ñÈ¡µ±Ç°Êý¾Ý¿âÓïÑÔ
SELECT @@LANGUAGE AS 'Language Name'
--Ìá¸ßSQLÐÔÄܼӿìÖ´ÐÐËÙ¶È
--µ«SET NOCOUNT ΪON£¬²»·µ»Ø¼ÆÊý£¬µ«SET NOCOUNTΪOFFÊÇ·µ»Ø¼ÆÊý¡£
--¼´Ê¹µ±SET NOCOUNTΪONʱ£¬Ò²¸üÐÂ@@ROWCOUNTº¯Êý£¬½«²»¸ø¿Í»§¶Ë·¢
--ËÍ´æ´¢¹ý³ÌÖеÄÿ¸öÓï¾äµÄDONEIN_PROC
--¿ØÖÆÅú´¦ÀíÓï¾äµÄÖ´ÐÐ
--µ±SET NOEXECΪONʱSQL Server±àÒëÿ¸öÅú´¦ÀíTransat-SQLÓï¾äµ«²¢²»Ö´ÐÐËüÃÇ¡£
--µ±SET NOEXECΪOFFʱ£¬ËùÓеÄÅú´¦ÀíÔÚ±àÒëºóÖ´ÐС£


Ïà¹ØÎĵµ£º

SQL×¢Èë

Ëæ×ÅB/SģʽӦÓÿª·¢µÄ·¢Õ¹£¬Ê¹ÓÃÕâÖÖģʽ±àдӦÓóÌÐòµÄ³ÌÐòÔ±Ò²Ô½À´Ô½¶à¡£µ«ÊÇÓÉÓÚÕâ¸öÐÐÒµµÄÈëÃÅÃż÷²»¸ß£¬³ÌÐòÔ±µÄˮƽ¼°¾­ÑéÒ²²Î²î²»Æë£¬Ï൱´óÒ»²¿·Ö³ÌÐòÔ±ÔÚ±àд´úÂëµÄʱºò£¬Ã»ÓжÔÓû§ÊäÈëÊý¾ÝµÄºÏ·¨ÐÔ½øÐÐÅжϣ¬Ê¹Ó¦ÓóÌÐò´æÔÚ°²È«Òþ»¼¡£Óû§¿ÉÒÔÌá½»Ò»¶ÎÊý¾Ý¿â²éѯ´úÂ룬¸ù¾Ý³ÌÐò·µ»ØµÄ½á¹û£¬»ñµÃijЩËûÏëµÃÖªµÄÊ ......

fastreport´òÓ¡´úÂë¼°SQLºÏ²¢×ֶεÄÓï¾ä

 procedure Tform1.Button5Click(Sender: TObject);
var
  p:pointer;
  FrfStr:string;
begin
  inherited;
  Screen.Cursor:=MYCURSORWAITHAND;
  with cdsPrint do
  begin
    Active:=false;
    //Õâ¸öSQLÓÃÓÚ½«remarkÖеļǼºÏ²¢µ½Ò»Æ ......

SQL²éѯÓï¾ä´óÈ« T

 --Óï ¾ä                                ¹¦ ÄÜ
1¡¢Êý¾Ý²Ù×÷
Select      --´ÓÊý¾Ý¿â±íÖмìË÷Êý¾ÝÐкÍÁÐ
Insert & ......

ÔÚSQLÖÐSelectÓï¾äµÄÖ´ÐÐ˳Ðò

ÔÚSQLÖÐSelectÓï¾äµÄÖ´ÐÐ˳ÐòÈçÏ£º
(1)from×Ӿ䣬×é×°À´×Ô²»Í¬Êý¾ÝÔ´µÄÊý¾Ý
(2)WHERE×Ӿ䣬¸øÓèÖ¸¶¨Ìõ¼þ¶Ô¼Ç¼½øÐÐɸѡ
(3)GROUP BY×Ӿ䣬½«Êý¾Ý»®·ÖΪ¶à¸ö×é
(4)ʹÓþۼ¯º¯Êý½øÐмÆËã
(5)ʹÓÃHAVING×Ó¾äɸѡ·Ö×é
(6)¼ÆËãËùÓбí´ïʽ
(7)ʹÓÃORDER BY¶Ô½á¹û½øÐÐÅÅÐò ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ