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

SQL SERVERµ¼ÈëBAKÎļþ

ϵͳ»·¾³£ºwindows xp pro
Êý¾Ý¿â£ºMS Sql 2000
IIS: 5.1 ASP.NET2.0
ÒòΪ´úÂëÊÇ2.0.netµÄ,ûÓа취ֻºÃ°²×°ÁË.netÏÂÔØÄã¿ÉÒÔȥ΢ÈíµÄÍøÕ¾ÉÏÈ¥ÏÂÔØ.Õâ¸öÊÇÃâ·ÑµÄÈí¼þ£¬ÎÒÖªµÀµÄÊÇÃâ·ÑµÄ¡£
Êý¾Ý¿â×öÁËѹËõºó׺ÊÇbakµÄ£¬ËùÒÔÊý¾Ý¿â²»ÄÜÖ±½ÓʹÓã¬ÐèÒªµ¼ÈëÔÚÍøÉϲéÁ˺ܶàµÄ×ÊÁϵ«ÊDz»¶à£¬µ«×Ô¼º³É¹¦µ¼ÈëÁË£¬Ð´ÏÂÀ´×öÒ»¸ö±¸ÍüÒÔÃâÒÔºóÓÖÍü¼ÇÁË¡£
Ê×ÏÈ´ò¿ªSQLµÄÆóÒµ¹ÜÀí¹¤¾ß£¬´ò¿ªÊý¾Ý¿âÏî¿ÉÒÔ¿´µ½×ó²àÓкܶàµÄÊý¾Ý¿â£¬ÄǸöϵͳ×Ô´øµÄ²»Òª¶¯£¬ÔÚÓÒ²à¿Õ°×´¦µãÓÒ¼üÑ¡“ËùÓÐÈÎÎñ”“»¹Ô­Êý¾Ý¿â”ÔÚ“»¹Ô­”ºóÓÐÈý¸öÑ¡ÏîÒÀ´ÎÊÇ“Êý¾Ý¿â”“Îļþ×é»òÎļþ”“´ÓÉ豸”Ñ¡Ôñ“´ÓÉ豸”ÔÚ“²ÎÊý”Ñ¡ÔñÒ»¸öÉ豸£¬Õâ¸öÆäʵ¾ÍÊÇÄã´æ·ÅBAKÎļþµÄ´ÅÅÌ£»ÁíÒ»¸öÎÊÌâ¾ÍÊÇÑ¡Ôñ“Ñ¡Ïî”Ñ¡Ôñ“ÔÚÏÖÓÐÊý¾Ý¿âÉÏÇ¿ÖÆ»¹Ô­”È»ºó´òµ½ÄãÒª»¹Ô­µÄBAKÊý¾Ý¿âÑ¡»¹Ô­¾Í¿ÉÒÔÁË¡£
ÔÚ»¹Ô­µÄ¹ý³ÌÖÐÓöµ½Ò»¸ö´íÎóµÄÌáʾ´óÌåÒâ˼ÊÇ˵É豸´íÎó»òËð»µÎÞ·¨»¹Ô­Ö¸¶¨µÄÊý¾Ý¿â£¬¿ªÊ¼µÄʱºò×Ô¼ºÒÔΪÊÇSQLÓÐÎÊÌâµÄ£¬ºóÀ´×Ðϸ¿´ÁËһϷ¾¶£¬Ô­À´ÊÇĬÈϵÄ·¾¶²»´æÔÚÔì³É´íÎóµÄÌáʾ£¬ÒòΪ×Ô¼ºÔÚ°²×°SQLµÄʱºò°ÑĬÈÏ´æ·ÅÊý¾Ý¿âµÄ·¾¶ÐÞ¸ÄÁË£¬ËùÒÔÔì³ÉÁË´íÎó£¬Õâ¸öÎÊÌâ±È½ÏºÃ½â¾ö£¬¾ÍÊǰÑÒª»¹Ô­µÄÊý¾Ý¿âÖØÐÂÖ¸¶¨Ò»Ï·¾¶ÎÊÌâ¾Í¿ÉÒÔ½â¾öÁË£¡


Ïà¹ØÎĵµ£º

SQLÓïÑÔ»ù±¾ÓïÑÔ

SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database db ......

¿ª·¢¸¨Öú¹¤¾ß£ºSQLÎĸñʽ»¯¹¤¾ßSQLinFormpro_Desktop

    ÔÚÓйØÊý¾Ý¿âµÄÏîÄ¿¿ª·¢ÖУ¬±àÂ룬bugÐ޸ĵȵȣ¬¶¼ÐèÒª²é¿´²Ù×÷Ïà¹ØµÄSQLÎÄ£¬Èç¹ûSQLÎıȽϸ´Ôӵϰ£¬ÎÒÃÇ×Ô¼ºÅŰæ·Ç³£Âé·³£¬Í¬Ê±Ò²ºÜ»¨·Ñʱ¼ä¡£¿ÉÄÜÓеĹ«Ë¾×Ô¼º¿ª·¢Á˸ñʽ»¯¹¤¾ß»òÕß¹ºÂòÁ˸ñʽ»¯¹¤¾ßÈí¼þ¡£ÓÐÁ˸ñʽ¹¤¾ßÎÒÃǾͽÚÊ¡ÁËÅŰæÊ±¼ä¡£
    ½éÉÜÒ»ÏÂSQLinFormpro_Desktop£¨htt ......

SQLÓï¾ä¾­µäʵÀý

ÎÞÂÛÄúÊÇһλ SQL µÄÐÂÊÖ£¬»òÊÇһλֻÊÇÐèÒª¶Ô SQL ¸´Ï°Ò»ÏµÄ×ÊÁϲִ¢Òµ½çÀϽ«£¬Äú¾ÍÀ´¶ÔµØ·½ÁË£¡
- SQL Ö¸Áî: SQL ÈçºÎ±»ÓÃÀ´´¢´æ¡¢¶ÁÈ¡¡¢ÒÔ¼°´¦ÀíÊý¾Ý¿âÖ®ÖеÄ×ÊÁÏ¡£
- ±í¸ñ´¦Àí: SQL ÈçºÎ±»ÓÃÀ´´¦ÀíÊý¾Ý¿âÖеıí¸ñ¡£
- SQLÓï·¨: ÕâÒ»Ò³ÁгöËùÓÐÔÚÕâ¸ö½Ì²ÄÖб»Ìáµ½µÄ SQL Óï·¨
SQL SELECT
Store_Information ±í¸ñ ......

SQLÓïÑԵIJ¼¾ÖºÍIllegalArgumentException

ºÍjava.lang.IllegalArgumentException: org.hibernate.QueryException: JPA-style positional param was not an integral ordinalÕ½¶·Á˰ëÌ죬º¹°¡£¡
ʹÓÃjpa + strut+ hibernate ¾Í±¨org.hibernate.QueryException: JPA-style positional param was not an integral ordinal
Ò»°ã°ÑhqlÓï¾äдÔÚÒ»ÐУ¬»áºÜ³¤£¬ÔÚideÖÐÐèÒ ......

access ·ÖÒ³Óà SQL²éѯÓï¾ä

select top ÿҳÏÔʾµÄ¼Ç¼Êý * from topic where id not in (select top £¨µ±Ç°µÄÒ³Êý-1£©×ÿҳÏÔʾµÄ¼Ç¼Êý id from topic order by id desc) order by id desc
select top ÿҳÏÔʾµÄ¼Ç¼Êý * from topic where id not in (select top £¨µ±Ç°µÄÒ³Êý-1£©×ÿҳÏÔʾµÄ¼Ç¼Êý id from topic order by id desc) ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ