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

SQL²éѯÿÐÐÖÐ×î´óÖµµÄ¼¼ÇÉ

--------------------------------------------------------------------------
--  Author : htl258(Tony)
--  Date   : 2010-04-23 08:08:36
--  Version:Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
--          Jul  9 2008 14:43:34
--          Copyright (c) 1988-2008 Microsoft Corporation
--          Developer Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
--  Blog   : http://blog.csdn.net/htl258
--  Subject: SQL²éѯÿÐÐÖÐ×î´óÖµµÄ¼¼ÇÉ
--------------------------------------------------------------------------
--> Éú³É²âÊÔÊý¾Ý±í:tb
 
IF NOT OBJECT_ID('[tb]') IS NULL
    DROP TABLE [tb]
GO
CREATE TABLE [tb](
a SMALLINT,
b SMALLINT,
c SMALLINT,
d SMALLINT,
e SMALLINT,
f SMALLINT,
g SMALLINT
)
INSERT [tb]
SELECT 1,2,3,4,5,2,3 UNION ALL
SELECT 4,5,6,7,7,2,0 UNION ALL
SELECT 4,9,6,7,7,9,6
GO
--SELECT * from [tb]
 
-->SQL²éѯÈçÏÂ:
 
SELECT *,
    (SELECT MAX(a)
     from(
       SELECT a UNION ALL
       SELECT b UNION ALL
       SELECT c UNION ALL
       SELECT d UNION ALL
       SELECT e UNION ALL
       SELECT f UNION ALL
       SELECT g
       ) AS t  
    ) AS maxvalue
from tb
 
 
/*
a      b      c      d      e      f      g      maxvalue
------ ------ ------ ------ ------ ------ ------ --------


Ïà¹ØÎĵµ£º

ÓÃsql²Ù×÷oracleµÄblob×Ö¶Î

ÓÃsql²Ù×÷oracleµÄblob×Ö¶Î
1¡¢²éѯ
select utl_raw.cast_to_varchar2(dlob),id from system.t_htinfo 
2¡¢²åÈë
insert into system.t_htinfo  values ('3',utl_raw.cast_to_raw('Äã'));
3¡¢¸üÐÂ
update system.t_htinfo set fld_value=utl_raw.cast_to_raw('1') where fh_nm=1820648 and form_index=52
......

windows 2003ϰ²×° sql server 2000µÄ·½·¨

    ÎÒ°²×°µÄÊÇsql server 2000ËĺÏÒ»°æ±¾£¬Õý³£Í¾¾¶Ö±½Ó°²×°ÊÇ×°²»Éϵģ¬Òª´òʲôSP3²¹¶¡£¬²»ÒªÀíËü£¬´ò¿ª°²×°°ü£¬Àï±ßÓиöMSDEĿ¼£¬Ö´ÐÐsetup.exe£¬°²×°ºÜ˳Àû£¬×°ÍêÖ®ºóÊÇûÓз´Ó¦µÄ£¬ÖØÆô¼ÆËã»ú£¬È»ºóÄÜ¿´µ½sql server·þÎñÒѾ­Æô¶¯£¬ÕâÑù£¬¾Í¿ÉÒÔÕý³£°²×°ÁË£¬Ö´Ðа²×°°ü¸ùĿ¼Ïµİ²×°³ÌÐò£¬°´Ìáʾһ²½ ......

³£ÓÃSQLÃæÊÔÌâ £¨Ò»£©

Êý¾Ý¿âÃæÊÔ³£ÓòâÊÔÌâ(SQL Server)
ÌâÄ¿1
¡¡¡¡ÎÊÌâÃèÊö:
¡¡¡¡Îª¹ÜÀí¸ÚλҵÎñÅàѵÐÅÏ¢£¬½¨Á¢3¸ö±í:
¡¡¡¡S (S#,SN,SD,SA) S#,SN,SD,SA ·Ö±ð´ú±íѧºÅ¡¢Ñ§Ô±ÐÕÃû¡¢ËùÊôµ¥Î»¡¢Ñ§Ô±ÄêÁä
¡¡¡¡C (C#,CN ) C#,CN ·Ö±ð´ú±í¿Î³Ì±àºÅ¡¢¿Î³ÌÃû³Æ
¡¡¡¡SC ( S#,C#,G ) S#,C#,G ·Ö±ð´ú±íѧºÅ¡¢ËùÑ¡Ð޵Ŀγ̱àºÅ¡¢Ñ§Ï°³É¼¨
¡¡¡¡1. Ê¹Ó ......

SQLÊý¾Ý¿â»Ö¸´Ä£ÐÍ(ÈÕÖ¾)

----------------------------------------------------------------------
1¡¢SQLÊý¾Ý¿â»Ö¸´Ä£ÐÍ
----------------------------------------------------------------------
1£©ÍêÈ«»Ö¸´Ä£ÐÍ
-----------------
£¨1£©±¸·ÝʱҪ±¸·ÝÊý¾Ý¿âµÄÊý¾ÝÎļþºÍÈÕÖ¾Îļþ
£¨2£©»¹Ô­Ê±Ê¹ÓÃÊý¾Ý¿âµÄ±¸·ÝµÄÊý¾ÝÎļþ¸±±¾ºÍÈ«²¿ÈÕÖ¾ÐÅ ......

Éî¶È¶Ô±ÈOracleÓëSQL Server – µÚÒ»²¿·Ö


²Ù
×÷ϵͳµÄÖ§³Ö
°æ
±¾ºÍ·¢Ðаæ
ʵ
Àý¡¢Êý¾Ý¿âºÍ±í¿Õ¼ä
ʵ
ÀýÃûºÍSID
ϵ
ͳÊý¾Ý¿âºÍϵͳ±í¿Õ¼ä
 
±¾ÒëÎIJÉÓÃ֪ʶ¹²ÏíÊð
Ãû-·ÇÉÌÒµÐÔʹÓÃ-Ïàͬ·½Ê½¹²Ïí 3.0 UnportedÐí¿ÉЭÒé
·¢²¼£¬×ªÔØÇë±£Áô´ËÐÅÏ¢
ÒëÕߣºÂí³ÝÜÈ | Á´½Ó£ºhttp://www.dbabeta.com/2010/oracle-sql-server-comparison-i.html
×÷ÕߣºS ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ