ÓÃ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 µÄ·þÎñÕË»§ÊÇʲô£¿
Ïà¹ØÎÊ´ð£º
ÈçºÎ½«sqlserver ±íµÄÒ»¸ö×ֶεÄÖµ¼ÓÉÏͬһ¸öÖµ£¿
ÊÇÉí·ÝÖ¤µ¼³öexcel±ä¿ÆÑ§¼ÆÊý·¨£¬Ï뽫ÕâÒ»×ֶεÄÖµÖ±½Ó¼ÓÉÏÒ»¸ö ¡¯
ÇëÎÊÈçºÎд£¿
SQL code:
update ry set Éí·ÝÖ¤ºÅ=Éí·ÝÖ¤ºÅ+'*'
UPdateÒ»Ï ......
SQL code:
begin tran
update EB with(rowlock) set Name='abc123' where Code=12 waitfor delay '00:00:13'
commit tran
ÎÒÓÃrowlockÏëËø¶¨Ò»ÐУ¬¿ÉÊÇËü°ÑÕû¸ö±í¶¼Ëø¶¨ÁË¡£²»¹ÜÎÒ¸üÐÂÄÄÒ»ÌõÊý¾Ý¶¼ ......
±ÈÈç Óû§Ãû£¬ÎÒ³ÌÐòµÄÒªÇóÊÇ10λ×Ö·ûÒÔÄÚ£¬ËùÒÔ£º
Èç¹ûÎÒsqlserver´Óvarchar(50)´æ´¢¸ÄΪÓÃvarchar(10)µÄ»°£¬
1.»á²»»á¼õÉÙÊý¾Ý¿Õ¼ä£¿
2.»á²»»áÌá¸ßÎÒ³ÌÐòµÄЧÂÊ£¿
3.ÓÐûÓбØÒª£¿
СµÜÏÈл ......
sqlserver´æ´¢¹ý³Ì¸Äoracle
˻ᰡ¡£¡£¡£°ïæ¸Ä¸Ä··
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER PROCEDURE tp_Fetch_List(
  ......
sqlserver Õ¼ÓÃÄÚ´æÌ«¸ßÔõô½â¾ö?
sqlserver 2000 sp4,xp ϵͳ£¬ÎÒ×Ô¼ºµÄ»ú×ÓÊÇ¿ª·¢»ú£¬Õ¼ÓÃÄÚ´æÌ«¸ßÁË£¬»ú×Ó·´Ó¦Âý£¬ÇëÎÊÓÐûÕë¶Ô¿ª·¢µÄÅäÖã¬ÈÃsqlserverÔÚºǫ́ÅÜÆðÀ´µÄʱºòÕ¼ÓÃÄÚ´æÉÔ΢Сһµã¡£Èç¹ûÓÐÓ¦ ......