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

ÓÃsqlserver 2000 agent µ÷ÓôòÓ¡»úÎÊÌâ

ÓÃ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 µÄ·þÎñÕË»§ÊÇʲô£¿


ÒýÓÃ


Ïà¹ØÎÊ´ð£º

jsp jdbcÁ¬½Ósqlserver 2000 ³öÏÖÎÊÌâ

´úÂ룺

try{
    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 
con= DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost: ......

ACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000

  ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......

SqlServer ËøµÄÎÊÌâ

SQL code:
begin tran
update EB with(rowlock) set Name='abc123' where Code=12 waitfor delay '00:00:13'
commit tran


ÎÒÓÃrowlockÏëËø¶¨Ò»ÐУ¬¿ÉÊÇËü°ÑÕû¸ö±í¶¼Ëø¶¨ÁË¡£²»¹ÜÎÒ¸üÐÂÄÄÒ»ÌõÊý¾Ý¶¼ ......

SqlServer´æ´¢½á¹¹ÓëÒ»¸öË÷ÒýÎÊÌâ

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 ......

ÇóÒ»»îÔ¾µÄsqlserverµÄqqȺ

ֻΪ¶úå¦Ä¿È¾£¬ÓÐËù½ø²½£¡
ßµ°Ý£¡
..

ÕâÀï¾ÍÊÇ

ÕâÀï±ÈQQȺÀïÈÈÄÖ

ÎÒÒ²ÏëÕÒÕâô¸öȺ

.

SQL code:
¡£¡£¡£¡£¡£

¡£

ºÇºÇ

ÒýÓÃ
ÕâÀï±ÈQQȺÀïÈÈÄÖ


ͬÒâ

發錯° ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ