ÓÃsqlserver 2000 agent Éú³ÉÒ»¸öjob£¬¸ÄjobÀïÃæÓе÷ÓÃÒ»¸öÓ¦ÓóÌÐò£¬¸ÃÓ¦ÓóÌÐò»áÈ¥µ÷´òÓ¡»ú´òÓ¡
µ¥¶ÀÅÜÕâ¸öÓ¦ÓóÌÐòµ÷´òÓ¡»úÊÇÕýÈ·µÄ£¬ È»ºóÓÃsqlserver 2005ÀïµÄagentÈ¥µ÷Ò²ÊÇ¿ÉÒÔÕý³£´òÓ¡µÄ¡£¡£¡£ ¾ÍÊÇÓÃsql 2000µÄʱºò»áÓÐÎÊÌâ¡£¡£¡£¹À¼ÆÊÇ»·¾³»òÕßÓÐʲô¶«Î÷ûװȫµÄÎÊÌ⣬Çë½Ì¸ßÊÖÓÐûÓÐÅöµ½¹ýÀàËÆÎÊÌ⣬Ôõô½â¾öµÄ
ûÓÐÅö¼û¹ý °ï¶¥
ÓÑÇé°ï¶¥
ÒýÓà ÓÃsqlserver 2000 agent Éú³ÉÒ»¸öjob£¬¸ÄjobÀïÃæÓе÷ÓÃÒ»¸öÓ¦ÓóÌÐò£¬¸ÃÓ¦ÓóÌÐò»áÈ¥µ÷´òÓ¡»ú´òÓ¡ µ¥¶ÀÅÜÕâ¸öÓ¦ÓóÌÐòµ÷´òÓ¡»úÊÇÕýÈ·µÄ£¬ È»ºóÓÃsqlserver 2005ÀïµÄagentÈ¥µ÷Ò²ÊÇ¿ÉÒÔÕý³£´òÓ¡µÄ¡£¡£¡£ ¾ÍÊÇÓÃsql 2000µÄʱºò»áÓÐÎÊÌâ¡£¡£¡£¹À¼ÆÊÇ»·¾³»òÕßÓÐʲô¶«Î÷ûװȫµÄÎÊÌ⣬Çë½Ì¸ßÊÖÓÐûÓÐÅöµ½¹ýÀàËÆÎÊÌ⣬Ôõô½â¾öµÄ ÊDz»ÊÇȨÏÞµÄÎÊÌâ¡£
¿´ÏÂϵͳÈÕÖ¾ÓÐûÓÐʲô±¨´íÐÅÏ¢
Â¥ÉÏÊÇ˵ sqlserverµÄȨÏÞÂð£¿
ÈÕÖ¾ÉÏû¶«Î÷£¬¾ÍÊdzÌÐò¿ªÊ¼¡£¡£¡£È»ºó¾ÍûÁË£¬²»³É¹¦Ò²²»Ê§°Ü£¬¾ÍÊdzöÓÚÒ»Ö±ÅܵÄ״̬¡£¡£¡£
µ÷ʽ³ÌÐò ¾ÍÊÇ´òÓ¡µÄʱºò³ö´íÁË
System.Drawing.Printing.PrintDocument pd =new System.Drawing.Printing.PrintDocument();
pd.PrintPage += new System.Drawing.Printing.PrintPageEventHandler(pd_PrintPage);
pd.Print();
¾ÍÊÇpd.Print();µÄʱºò³öÎÊÌâÁË¡£¡£¡£
ÓÑÇé°ï¶¥
°ï¶¥
µ÷ÓõÄÊDZ¾µØ´òÓ¡»ú£¬»¹ÊÇÍøÂç´òÓ¡»ú£¿
sql server 2000 µÄ sql server agent µÄ·þÎñÕË»§ÊÇʲô£¿
ÒýÓÃ
Ïà¹ØÎÊ´ð£º
´úÂ룺 try{ Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); con= DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost: ......
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý" ²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!! ´ó¼Ò¶¼ ......
SQL code: begin tran update EB with(rowlock) set Name='abc123' where Code=12 waitfor delay '00:00:13' commit tran ÎÒÓÃrowlockÏëËø¶¨Ò»ÐУ¬¿ÉÊÇËü°ÑÕû¸ö±í¶¼Ëø¶¨ÁË¡£²»¹ÜÎÒ¸üÐÂÄÄÒ»ÌõÊý¾Ý¶¼ ......
SQL code: CREATE TABLE TUser ( FName CHAR(8000), FAge INT, FSex bit ) INSERT INTO TUser SELECT 'ÕÅÈý',18,1 UNION ALL SELECT 'ÀîËÄ',20,1 UNION ALL SELECT 'ÍõÎå',32,1 UNION ALL SE ......
ֻΪ¶úå¦Ä¿È¾£¬ÓÐËù½ø²½£¡ ßµ°Ý£¡ .. ÕâÀï¾ÍÊÇ ÕâÀï±ÈQQȺÀïÈÈÄÖ ÎÒÒ²ÏëÕÒÕâô¸öȺ . SQL code: ¡£¡£¡£¡£¡£ ¡£ ºÇºÇ ÒýÓà ÕâÀï±ÈQQȺÀïÈÈÄÖ Í¬Òâ 發錯° ......