Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 Ëæ»ú³éÑùÎÒÃdz£Ïëµ½µÄ¾ÍÊÇnewid()£¬µ«Èç¹û¶ÔÓÚÒ»¸öÔÚ°ÙÍò¡¢Ç§ÍòÉõÖÁ¸ü´óº£Á¿Êý¾Ý±íÖгéÑùµÄ»°£¬¼òµ¥µÄnewid()£¬ÆäÐÔÄÜ£¬Ð§ÂʾͲ»ÊǺÜÀíÏëÁË¡£ËùÒÔÔÚÕâÀïÓбØÒªÌÖÂÛһϣ¬ÔñÓŶøÓá£
 
long_goodsÊÇÒ»¸ö°ÙÍòÊý¾ÝµÄ±í£¬Ctrl+LÖ´ÐÐÒÔÏÂÓï¾ä:
 
--id_indexÊÇÎÒΪÖ÷¼ü¼ÓµÄÒ»¸ö·Ç¾Û½¹Ë÷Òý
SELECT top 1&nb ......

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

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

SQL SERVERË÷Òý²Ù×÷Êý¾Ý¿â

Ë÷Òý²Ù×÷
Êý¾Ý¿âÖеÄË÷ÒýÓëÊé¼®ÖеÄË÷ÒýÀàËÆ£¬ÔÚÒ»±¾ÊéÖУ¬ÀûÓÃË÷Òý¿ÉÒÔ¿ìËÙ²éÕÒËùÐèÐÅÏ¢£¬ÎÞÐëÔĶÁÕû±¾Êé¡£ÔÚÊý¾Ý¿âÖУ¬Ë÷ÒýʹÊý¾Ý¿â³ÌÐòÎÞÐë¶ÔÕû¸ö±í½øÐÐɨÃ裬¾Í¿ÉÒÔÔÚÆäÖÐÕÒµ½ËùÐèÊý¾Ý¡£ÊéÖеÄË÷ÒýÊÇÒ»¸ö´ÊÓïÁÐ±í£¬ÆäÖÐ×¢Ã÷Á˸÷¸ö´ÊµÄÒ³Âë¡£¶øÊý¾Ý¿âÖеÄË÷ÒýÊÇij¸ö±íÖÐÒ»ÁлòÕßÈô¸ÉÁÐÖµµÄ¼¯ºÏ£¬ºÍÏàÓ¦µÄÖ¸Ïò±íÖÐÎïÀí±ê ......

SQL SERVER ͼ±íÊý¾Ý¿â

ͼ±í
ͼ±í(ÓֳƹØÏµÍ¼)ÊÇSQL ServerÖÐÒ»ÀàÌØÊâµÄÊý¾Ý¿â¶ÔÏó£¬ËüÌṩ¸øÓû§Ö±¹ÛµØ¹ÜÀíÊý¾Ý¿â±íµÄ·½·¨¡£Í¨¹ýͼ±í£¬Óû§¿ÉÒÔÖ±¹ÛµØ´´½¨¡¢±à¼­Êý¾Ý¿â±íÖ®¼äµÄ¹ØÏµ£¬Ò²¿ÉÒԱ༭±í¼°ÆäÁеÄÊôÐÔ¡£ÀûÓÃÆóÒµ¹ÜÀíÆ÷´´½¨Í¼±íµÄ¾ßÌå²½ÖèÈçÏ£º
(1)ÔÚÆóÒµ¹ÜÀíÆ÷ÖУ¬Õ¹¿ªÖ¸¶¨µÄ·þÎñÆ÷ºÍÊý¾Ý¿â£¬´ò¿ªÒª½¨Á¢µÄͼ±íËùÔÚµÄÊý¾Ý¿â£¬ÓÒ»÷ͼ±íÍ ......

×ܽáSQLite²»Ö§³ÖµÄSQLÓï·¨ÓÐÄÄЩ


1 TOP
ÕâÊÇÒ»¸ö´ó¼Ò¾­³£Îʵ½µÄÎÊÌ⣬ÀýÈçÔÚSQLSERVERÖпÉÒÔʹÓÃÈçÏÂÓï¾äÀ´È¡µÃ¼Ç¼¼¯ÖеÄǰʮÌõ¼Ç¼£º
SELECT TOP 10 * from [index] ORDER BY indexid DESC;
 
µ«ÊÇÕâÌõSQLÓï¾äÔÚSQLiteÖÐÊÇÎÞ·¨Ö´Ðеģ¬Ó¦¸Ã¸ÄΪ£º
SELECT * from [index] ORDER BY indexid DESC limit 0,10;
 
ÆäÖÐlimit 0,10±íʾ´ÓµÚ0 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ