Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 µÄ·þÎñÕË»§ÊÇʲô£¿


ÒýÓÃ


Ïà¹ØÎÊ´ð£º

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

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

sqlserver Êý¾ÝºÏ²¢ÎÊÌâ

ÏÈÓÉÈçÏÂsqlÓï¾ä
select  A,B,C from table1
union
select  A,B,C from table2
order by A, C asc
µÃµ½½á¹ûÈçÏ£º
  A        B      &nbs ......

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 µÄÊý¾Ý»¹Ô­

»¹Ô­µÄ±¨´íÐÅÏ¢:

System.Data.SqlClient.SqlError: ±¸·Ý¼¯ÖеÄÊý¾Ý¿â±¸·ÝÓëÏÖÓÐµÄ 'chat_Data' Êý¾Ý¿â²»Í¬¡£ (Microsoft.SqlServer.Smo)

Çë¸÷λ¸ßÊÖ°ïæ½â¾ö

»¹Ô­µÄÊý¾Ý¿âÃû×ÖÓ뱸·ÝµÄÊ ......

¼±ÇóÖúSqlserver´æ´í¹ý³Ì

CREATE PROCEDURE [dbo].[getNews]
@News_subject nvarchar(1000) =null,
@News_content nvarchar(max) =null,
@type int,
@FileName varchar(255) =null,
@descriptions nvarchar(1000) =null,
@ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ