Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Óï¾ä»ù±¾²Ù×÷

1.½¨±íÓï¾ä£ºcreate table
Ó÷¨: create table ±íµÄÃû×Ö (×Ö¶Î1, ×Ö¶Î2,¡£¡£¡£¡£)
¾ÙÀý£ºÀýÈç´´½¨Ò»¸öѧÉú³É¼¨±í£¬°üº¬µÄ×Ö¶ÎÓУ¬Ñ§Éúid£¬ÐÕÃû£¬ÐԱ𣬰༶£¬³É¼¨create table score(
create table score(
 sid nvarchar(10) primary key,
 sname nvarchar(10) not null,
 sex nvarchar(2),
 sc ......

mysqlµ¼ÈësqlÎļþ:Mysqlµ¼Èëµ¼³ö.sqlÎļþ

mysqlµ¼ÈësqlÎļþ:Mysqlµ¼Èëµ¼³ö.sqlÎļþ
²½ÖèÈçÏ£º
Ò».MYSQLµÄÃüÁîÐÐģʽµÄÉèÖãº
×ÀÃæ->ÎҵĵçÄÔ->ÊôÐÔ->»·¾³±äÁ¿->н¨->
PATH=“£»path\mysql\bin;”ÆäÖÐpathΪMYSQLµÄ°²×°Â·¾¶¡£
¶þ.¼òµ¥µÄ½éÉÜÒ»ÏÂÃüÁîÐнøÈëMYSQLµÄ·½·¨£º
1.C:\>mysql -h hostname -u username -p
°´ENTER ......

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ÖÐÐèÒ ......

ͬһ¸ö½»²æ±íµÄ¶¯Ì¬SQLʵÏÖ

DECLARE
 TYPE list IS TABLE OF t_stu.project%TYPE INDEX BY BINARY_INTEGER;
 project_list list;
 v_pro_num NUMBER;
 sql_str VARCHAR(255);
 
t_stu
SID SUBJECT SCORE
1        Êýѧ       &n ......

£¨×îгɹ¦£©Ãâ°²×°OracleÔËÐÐpl/sql developer

1.µ½http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/htdocs/winsoft.htmlÏÂÔØ
11.1.0.7.0 °æµÄ¼´Ê±¿Í»§¶Ë³ÌÐò°ü — Basic£¨²»ÊÇBasic Lite£©
2.½«ÏÂÔص½µÄÎļþ½âѹ£¬½âѹºóÎÒ½«Ä¿Â¼instantclient_11_1ÀïµÄÈ«²¿Îļþ¿½±´µ½ÁËÒ»¸öеÄĿ¼£ºE:\programs\OracleClient¡£ÄãÒ²¿ÉÒÔ²»¿½±´£¬Ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ