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

[SQL Server] µ¼³ö±í½á¹¹(Êý¾Ý×Öµä)

-- Êý¾Ý×Öµä
SELECT
        (case when a.colorder=1 then d.name else '' end)±íÃû,
        a.colorder ×Ö¶ÎÐòºÅ,
        a.name ×Ö¶ÎÃû,
        (case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√'else '' end) ±êʶ,
       (case when (SELECT count(*)
        from sysobjects
        WHERE (name in
                (SELECT name
                from sysindexes
                WHERE (id = a.id) AND (indid in
                         (SELECT indid
                        from sysindexkeys
                        WHERE (id = a.id) AND (colid in
                                  (SELECT colid
                                 from syscolumns
                               &nb


Ïà¹ØÎĵµ£º

SQL֪ʶ´óÔÓ»â


$$$Ϊÿ½ÚµÄ¿ªÊ¼
-------------------------------------------------------------------------------------------------------------------------------------------------
$$$ SQLÖÐϵͳÁÙʱ±íµÄʹÓúͽû¼É ¼° Exec(SQLScript) µÄʹÓÃ
ÒÔǰÔÚSQL ÖÐдSP ʱ£¬Èç±È½Ï¸´ÔÓʱ£¬Ï²»¶ÖмäʹÓÃÁÙʱ±íÀ´ÔÝ´æÏà¹Ø¼Ç¼£¬ÕâÑùµÄ ......

ʹÓÃjdbcÁ¬½ÓsqlÊý¾Ý¿â

»ù±¾ÉϾÍÊÇÕâЩ²½Ö裺
ÏÂÔØÄãÒªÁ¬½ÓµÄÊý¾Ý¿âµÄJDBCÇý¶¯³ÌÐò£¨driver£©¡£Í¨³£¶¼ÊÇÒ»¸öjarÎļþ£¬¸´ÖƵ½ÄãµÄprojectÀïÃæ£¬È·±£Ê¶±ðÕâ¸ö¿â¾Í¿ÉÒÔÁË¡£
¼ÓÔØÇý¶¯£¬ ²»Í¬µÄÊý¾Ý¿âÐèÒª²»Í¬ JDBC driver¡£
Á¬½ÓÊý¾Ý¿â£¬²»Í¬µÄÊý¾Ý¿âͬÑùÐèÒª²»Í¬µÄJDBC URL¡£
ÏÂÃæ¸ø³öÁ¬½Ó²»Í¬Êý¾Ý¿âµÄÀý×Ó
Á¬½Ó mini SQL
// Establish a ......

ʹÓÃT SQL»ñÈ¡µ½SQLServer IpºÍ¶Ë¿ÚºÅ

ÔÚÆ½Ê±µÄ¹¤×÷¹ý³ÌÖУ¬×÷ΪDBA½ÇÉ«¹ÜÀíÊý¾Ý¿â£¬Í·ÄÔÖеÄÓ¡ÏóÍùÍùÊÇÊý¾Ý¿âʵÀýÃû³Æ£¬¶ø²»»áÈ¥¹ØÐÄServerµÄIP£¬¶ø×÷ΪDeveloperµÄ½ÇÉ«£¬ËûÃÇÍùÍùÏëÖªµÀÖªµÀServer IpºÍ¶Ë¿ÚºÅ¡£ËùÒÔ£¬DBA»á¾­³£±»Îʼ°µ½£ºXXXʵÀýµÄIPºÍ¶Ë¿ÚºÅÊÇʲô£¿
Õâ¸öÎÊÌ⣬µ±È»ÎÒÃÇ¿ÉÒÔLoginµ½OS²é¿´IP¡¢Ê¹ÓÃÅäÖÆ¹ÜÀí¹¤¾ß»ñÈ¡µ½¶Ë¿ÚºÅ¡£µ«ÊÇ£¬Õâ¸ö·½·¨·Ç ......

sql server2000´æ´¢¹ý³Ì·þÎñÆ÷

´æ´¢¹ý³Ì
ÔÚ´óÐÍÊý¾Ý¿âϵͳÖУ¬Ëæ×Ź¦ÄܵIJ»¶ÏÍêÉÆ£¬ÏµÍ³Ò²±äµÃÔ½À´Ô½¸´ÔÓ£¬´óÁ¿µÄʱ¼ä½«»áºÄ·ÑÔÚSQL´úÂëºÍÓ¦ÓóÌÐò´úÂëÉÏ£¬¿öÇÒÔںܶàÇé¿öÏ£¬Ðí¶à´úÂë±»ÖØ¸´Ê¹Óöà´Î£¬Ã¿´Î¶¼ÊäÈëÏàͬµÄ´úÂë¼È·±ËöÓֻήµÍϵͳÔËÐÐЧÂÊ¡£Òò´Ë£¬SQL ServerÌṩÁËÒ»ÖÖ·½·¨£¬Ëü¿ÉÒÔ½«Ò»Ð©¹Ì¶¨µÄ²Ù×÷¼¯ÖÐÆðÀ´ÓÉSQL ServerÊý¾Ý¿â·þÎñÆ÷À´Íê³É£ ......

SQLÖг£¼ûº¯ÊýµÄÓ÷¨

1Replaceº¯Êý
ÔÚSQL SERVER 2000ÖÐÓÐÒ»¸öÐÅÏ¢±í£¬´æ·ÅÐÂÎÅÐÅÏ¢£¬ÏÖÔÚ¿Í»§ÏëÅúÁ¿¸üÐÂÕâ¸ö×Ö¶ÎÖеÄijЩÎÄ×Ö£¬Ì滻ΪÆäËûÎÄ×Ö¡£
½â¾ö·½·¨£ºÀûÓÃreplaceº¯Êý
update detail set content=replace(content,'Ô­ÎÄ×Ö','Ìæ»»ºóÎÄ×Ö') where Ìõ¼þ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ