Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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: ......

ÈçºÎ½«sqlserver ±íµÄÒ»¸ö×ֶεÄÖµ¶¼¼ÓÉÏͬһ¸öÖµ£¿

ÈçºÎ½«sqlserver ±íµÄÒ»¸ö×ֶεÄÖµ¼ÓÉÏͬһ¸öÖµ£¿

ÊÇÉí·ÝÖ¤µ¼³öexcel±ä¿ÆÑ§¼ÆÊý·¨£¬Ï뽫ÕâÒ»×ֶεÄÖµÖ±½Ó¼ÓÉÏÒ»¸ö ¡¯

ÇëÎÊÈçºÎд£¿
SQL code:
update ry set Éí·ÝÖ¤ºÅ=Éí·ÝÖ¤ºÅ+'*'

UPdateÒ»Ï ......

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 Õ¼ÓÃÄÚ´æÌ«¸ßÔõô½â¾ö?

sqlserver  Õ¼ÓÃÄÚ´æÌ«¸ßÔõô½â¾ö?
sqlserver 2000 sp4,xp ϵͳ£¬ÎÒ×Ô¼ºµÄ»ú×ÓÊÇ¿ª·¢»ú£¬Õ¼ÓÃÄÚ´æÌ«¸ßÁË£¬»ú×Ó·´Ó¦Âý£¬ÇëÎÊÓÐûÕë¶Ô¿ª·¢µÄÅäÖã¬ÈÃsqlserverÔÚºǫ́ÅÜÆðÀ´µÄʱºòÕ¼ÓÃÄÚ´æÉÔ΢Сһµã¡£Èç¹ûÓÐÓ¦ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ