»ñÈ¡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ÖÐÂß¼²éѯ´¦ÀíµÄ¸÷¸ö½×¶Î£¨×Ô¼º¸ãµÄÀý×Ó£¬²»¶ÔµÄ»¶ÓÖ¸ÕýŶ£©
SQL²»Í¬ÓÚÆäËûµÄ±à³ÌÓïÑÔµÄ×î´ó×î´óÌØÕ÷ÓÐ3¸ö°É£¬
Ò»¸öÊÇËüÊÇÃæÏò¼¯ºÏµÄ±à³Ì˼Ï룬µÚ¶þ¸öÊÇÈýÖµÂß¼£¨Õâ¸öºóÃæ»á˵µ½£©£¬»¹ÓÐÒ»¸ö¾ÍÊǽñÌìÖ÷ҪҪ˵µÄ²éÑ¯ÔªËØµÄÂß¼´¦Àí´ÎÐò¡£
Çë¿´Ò»¸ö»ù±¾²éѯµÄÂß¼¹ý³Ì£º
(8) SELECT (9) DISTINCT ( ......
--Óï ¾ä ¹¦ ÄÜ
1¡¢Êý¾Ý²Ù×÷
Select --´ÓÊý¾Ý¿â±íÖмìË÷Êý¾ÝÐкÍÁÐ
Insert & ......
http://cheneyph.javaeye.com/blog/453492
ÓÃoracle sql¶ÔÊý×Ö½øÐвÙ×÷: È¡ÉÏÈ¡Õû¡¢ÏòÏÂÈ¡Õû¡¢±£ÁôNλСÊý¡¢ËÄÉáÎåÈë¡¢Êý×Ö¸ñʽ»¯
È¡Õû£¨ÏòÏÂÈ¡Õû£©£º
select floor(5.534) from dual;
select trunc(5.534) from dual;
ÉÏÃæÁ½ÖÖÓ÷¨¶¼¿ÉÒÔ¶ÔÊý×Ö5.534ÏòÏÂÈ¡Õû£¬½á¹ûΪ5.
Èç¹ûÒªÏòÉÏÈ¡Õû £¬µÃµ½½á¹ûÎ ......
½»²æ±íÓï¾äµÄʵÏÖ:
¡¡¡¡ÓÃÓÚ:½»²æ±íµÄÁÐÊýÊÇÈ·¶¨µÄ
¡¡¡¡select name,sum(case subject when 'Êýѧ' then source else 0 end) as 'Êýѧ',
¡¡¡¡sum(case subject when 'Ó¢Óï' then source else 0 end) as 'Ó¢Óï',
¡¡¡¡sum(case subject when 'ÓïÎÄ' then source else 0 end) as 'ÓïÎÄ'
¡¡¡¡from test
¡¡¡¡group by name ......
http://cheneyph.javaeye.com/blog/477829
ÔÚJavaÖУ¬»ñµÃResultSetµÄ×ÜÐÐÊýµÄ·½·¨ÓÐÒÔϼ¸ÖÖ¡£
µÚÒ»ÖÖ£ºÀûÓÃResultSetµÄgetRow·½·¨À´»ñµÃResultSetµÄ×ÜÐÐÊý
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABL ......