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

ʹÓÃSQLÖØÉèÊý¾Ý¿âSequenceµÄµ±Ç°Öµ

ºÜ¶àʱºò£¬ÎÒÃÇÐèÒª°ÑÊý¾Ý¿âSequenceÉèÖõ½Ä³¸öÌØ¶¨µÄÖµ¿ªÊ¼£¬µ«ÊÇÓÖ²»ÏëÖØ½¨Õâ¸öSequence ÄÇÏÂÃæµÄSQLÓï¾ä¾Í¿ÉÒÔʵÏÖÕâÑùµÄ¹¦ÄÜ£º ÆäÖÐuser_seqÊÇÐèÒª²Ù×÷µÄSequenceÃû³Æ£¬1 .. 100ÊǵÝÔö100´Î DECLARE
rowCount1 NUMBER;
BEGIN
FOR cc IN 1 .. 100
LOOP
SELECT user_seq.NEXTVAL INTO rowCount1 from DUAL;
END LOOP;
END;


Ïà¹ØÎĵµ£º

SQL Server µÄͨÓ÷ÖÒ³ÏÔʾ´æ´¢¹ý³Ì

ת×Ô£ºhttp://hi.baidu.com/sonichu/blog/item/a494c4ea276f12dad539c9a8.html
½¨Á¢Ò»¸ö Web Ó¦Ó㬷ÖÒ³ä¯ÀÀ¹¦Äܱز»¿ÉÉÙ¡£Õâ¸öÎÊÌâÊÇÊý¾Ý¿â´¦ÀíÖÐÊ®·Ö³£¼ûµÄÎÊÌâ¡£¾­µäµÄÊý¾Ý·ÖÒ³·½·¨ÊÇ:ADO ¼Í¼¼¯·ÖÒ³·¨£¬Ò²¾ÍÊÇÀûÓÃADO×Ô´øµÄ·ÖÒ³¹¦ÄÜ£¨ÀûÓÃÓα꣩À´ÊµÏÖ·ÖÒ³¡£µ«ÕâÖÖ·ÖÒ³·½·¨½öÊÊÓÃÓÚ½ÏСÊý¾ÝÁ¿µÄÇéÐΣ¬ÒòΪÓα걾ÉíÓÐȱ ......

SQL²éѯÐÔÄÜÓÅ»¯

Ò».Ãû´Ê½âÊÍ£º
0¡£SQL ½á¹¹»¯²éѯÓïÑÔ(Structured Query Language)
1¡£·Ç¹ØÏµÐÍÊý¾Ý¿âϵͳ
×öΪµÚÒ»´úÊý¾Ý¿âϵͳµÄ×ܳƣ¬Æä°üÀ¨2ÖÖÀàÐÍ£º“²ã´Î”Êý¾Ý¿âÓë“Íø×´”Êý¾Ý¿â
“²ã´Î”Êý¾Ý¿â¹ÜÀíϵͳ eg:IBM&IMS (Information Management System ......

ODBCÁ¬½Ósybase sql anywhere open server

¾ßÌå²½Ö裺
¡¡¡¡Ò».ÔÚ·þÎñÆ÷¶ËÒÔ
dbsrv7.exe pathyyy.db -n
ServiceName -x tcpip -q
¡¡¡¡Æô¶¯Êý¾Ý¿â£¬ÕâÀïÒ²¿ÉÒÔÖ¸¶¨¶Ë¿Ú£¬ÏêϸµÄ²ÎÊýÇëÓÃdbsrv7.exe /?»ñÈ¡¡£
¡¡¡¡-n servicename:Æô¶¯·þÎñÃûΪservicenameµÄÊý¾Ý¿â·þÎñÓÃÒÔ±ê¼ÇÍøÂçÊý¾Ý¿â·þÎñΨһ±ê¼Ç£»
¡¡¡¡-x tcpip£ºÊ¹ÓÃtcp/ipЭÒ飬ĬÈ϶˿Ú3362,×¢Òâ²»Òª± ......

ORACLE³£ÓÃSQLÓÅ»¯hintÓï¾ä

PowerBuilderÈ¡µÃ¾Þ´ó³É¾ÍµÄÔ­Òò¾ÍÊÇÓй¦ÄÜÇ¿´óºÍÁé»î¶à±äµÄDatawindow¶ÔÏ󣬱¾ÈËÓÃPowerBuilder¿ª·¢¹ýÒ»¶Îʱ¼äºó£¬×ܽá³öһЩ¼¼ÇÉ£¬ÒÔ¹©¹ã´óµÄPB¿ª·¢Õß½è¼øÊ¹Óá£
1¡¢ ÈçºÎ´´½¨Ò»¸ö¾ßÓÐÖð½¥µÝÔöÇóºÍ¹¦Äܵı¨±í£¬ÈçÏÂÐÎʽ£º Running TotalÁУ¬ÎÒÃÇ¿ÉʹÓüÆËãÁУºCumulativeSum£¨Quantity for all£©£¬¼´¿É´ïµ½Öð½¥µÝÔöÇóºÍ ......

sql ÐÐתÁÐ

1¡¢ Ç¿´óµÄgroup by 1 select stdname,2 isnull(sum( case stdsubject when ' »¯Ñ§ ' then Result end), 0 ) [»¯Ñ§],3 isnull(sum( case stdsubject when ' Êýѧ ' then Result end), 0 ) [Êýѧ],4 isnull(sum( case stdsubject when ' ÎïÀí ' then Result end), 0 ) [ÎïÀí],5 isnull(sum( case stdsubject when ' ÓïÎÄ ' t ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ