MS SQL2000Êý¾Ý¿â×Ô¶¯±¸·ÝµÄ¼¸ÖÖ·½·¨£¨ms sql 2000 £©
Ò»¡¢¼òµ¥ÊµÓõı¸·Ý·½·¨£º
ÆóÒµ¹ÜÀíÆ÷ÖеÄTools£¬Database Maintenance Planner£¬¿ÉÒÔÉèÖÃÊý¾Ý¿âµÄ¶¨ÆÚ×Ô¶¯±¸·Ý¼Æ»®¡£²¢Í¨¹ýÆô¶¯Sql server AgentÀ´×Ô¶¯ÔËÐб¸·Ý¼Æ»®¡£¾ßÌå²½ÖèÈçÏÂ:
1¡¢´ò¿ªÆóÒµ¹ÜÀíÆ÷£¬ÔÚ¿ØÖÆ̨¸ùĿ¼ÖÐÒÀ´Îµã¿ªMicrosoft SQL Server-->SQL Server×é-->Ë«»÷´ò¿ªÄãµÄ·þÎñÆ÷
2¡¢È»ºóµãÉÏÃæ²Ëµ¥ÖеŤ¾ß-->Ñ¡ÔñÊý¾Ý¿âά»¤¼Æ»®Æ÷
3¡¢ÏÂÒ»²½Ñ¡ÔñÒª½øÐÐ×Ô¶¯±¸·ÝµÄÊý¾Ý-->ÏÂÒ»²½¸üÐÂÊý¾ÝÓÅ»¯ÐÅÏ¢£¬ÕâÀïÒ»°ã²»ÓÃ×öÑ¡Ôñ-->ÏÂÒ»²½¼ì²éÊý¾ÝÍêÕûÐÔ£¬Ò²Ò»°ã²»Ñ¡Ôñ
4¡¢ÏÂÒ»²½Ö¸¶¨Êý¾Ý¿âά»¤¼Æ»®£¬Ä¬ÈϵÄÊÇ1Öܱ¸·ÝÒ»´Î£¬µã»÷¸ü¸ÄÑ¡ÔñÿÌ챸·ÝºóµãÈ·¶¨
5¡¢ÏÂÒ»²½Ö¸¶¨±¸·ÝµÄ´ÅÅÌĿ¼£¬Ñ¡ÔñÖ¸¶¨Ä¿Â¼£¬ÈçÄú¿ÉÒÔÔÚDÅÌн¨Ò»¸öĿ¼È磺d:\databak£¬È»ºóÔÚÕâÀïÑ¡ÔñʹÓôËĿ¼£¬Èç¹ûÄúµÄÊý¾Ý¿â±È½Ï¶à×îºÃÑ¡ÔñΪÿ¸öÊý¾Ý¿â½¨Á¢×ÓĿ¼£¬È»ºóÑ¡Ôñɾ³ýÔçÓÚ¶àÉÙÌìÇ°µÄ±¸·Ý£¬Ò»°ãÉ趨4£7Ì죬Õâ¿´ÄúµÄ¾ßÌ屸·ÝÒªÇ󣬱¸·ÝÎļþÀ©Õ¹ÃûĬÈϵÄÊÇBAK
6¡¢ÏÂÒ»²½Ö¸¶¨ÊÂÎñÈÕÖ¾±¸·Ý¼Æ»®£¬¿´ÄúµÄÐèÒª×öÑ¡Ôñ-->ÏÂÒ»²½ÒªÉú³ÉµÄ±¨±í£¬Ò»°ã²»×öÑ¡Ôñ-->ÏÂÒ»²½Î¬»¤¼Æ»®ÀúÊ·¼Ç¼£¬×îºÃÓÃĬÈϵÄÑ¡Ïî-->ÏÂÒ»²½Íê³É
7¡¢Íê³ÉºóϵͳºÜ¿ÉÄÜ»áÌáʾSql Server Agent·þÎñδÆô¶¯£¬ÏȵãÈ·¶¨Íê³É¼Æ»®É趨£¬È»ºóÕÒµ½×ÀÃæ×îÓÒ±ß״̬À¸ÖеÄSQLÂÌɫͼ±ê£¬Ë«»÷µã¿ª£¬ÔÚ·þÎñÖÐÑ¡ÔñSql Server Agent£¬È»ºóµã»÷ÔËÐмýÍ·£¬Ñ¡ÉÏÏ·½µÄµ±Æô¶¯OSʱ×Ô¶¯Æô¶¯·þÎñ
8¡¢¿ÉÒÔÉèÖÃÆô¶¯Æô¶¯sql server Agent:ÔËÐÐServices.msc£¬ÉèÖÃsqlserverAgentΪ×Ô¶¯Æô¶¯¡£
Ð޸ı¸·Ý¼Æ»®£º
´ò¿ªÆóÒµ¹ÜÀíÆ÷£¬ÔÚ¿ØÖÆ̨¸ùĿ¼ÖÐÒÀ´Îµã¿ªMicrosoft SQL Server-->SQL Server×é-->Ë«»÷´ò¿ªÄãµÄ·þÎñÆ÷-->¹ÜÀí-->Êý¾Ý¿âά»¤¼Æ»® ¡¡
¶þ¡¢ÒìµØ±¸·Ý
ÔËÐл·¾³·ÖÎö£º
ÏÖÓÐÁ½Ì¨»úÆ÷¾ßÌåÅäÖÃÈçÏ£º
²Ù×÷ϵͳ£ºÁ½Ì¨¶¼ÊÇWindows 2000 Advanced Server
Êý¾Ý¿â£º Sql Server 2000
IP: һ̨ÊÇ192.168.0.1£¬Áíһ̨ÊÇ192.168.0.100
ÒªÇ󣺶¨ÆÚ×Ô¶¯ÊµÏÖ½«192.168.0.1ÖÐÊý¾Ý¿âÖÐbbsbakÊý¾Ý¿â±¸·Ýµ½192.168.0.100µÄ»úÆ÷ÉÏ£¬²¢É¾³ý15ÌìÒÔÇ°¶Ô192.168.0.100ÖÐ×Ô¶¯±¸·ÝµÄbbsbakÊý¾Ý¿â¡£
×¢£º±¾²Ù×÷Éæ¼°µ½Ms Sql Server2000Êý¾Ý¿âÊý¾Ýת»»·þÎñÖаüµÄ¸ß¼¶ÉèÖá¢Êý¾Ý¿â´æ´¢¹ý³Ì¡¢×÷ÒµµÄÌí¼Ó¼°¼òµ¥Transact_SQLÓï¾äµÄ²Ù×÷µÈÄÚÈÝ£¬Ôڴ˲»ÔÙÏêÊö£¬Çë²Î¿¼Ïà¹Ø×ÊÁϼ°Î¢Èí¹Ù·½ÍøÕ¾¡£
²Ù×÷²½Ö裺
1. ÔÚ±¾»ú£¨win2000£©Öдò¿ªSQLÊý¾Ý¿â¨D¨D£Êý¾Ýת»»·þÎñ¨D¨D±¾µØ°ü£¨Èçͼ£©
screen.width*0.7) {this
Ïà¹ØÎĵµ£º
http://hi.baidu.com/gushu/blog/item/3e821c174eabec064a90a7d4.html
mysql5Ìí¼ÓÁËһЩÐµĹ¦ÄܵĹæÔò£¬ÆäÖжԿªÔ´³ÌÐòÓ°Ïì±È½Ï´óµÄÓÐÁ½¸ö£¬Ò»¸öÊÇ4.0.12+¿ªÊ¼µÄ4²ã´Î×Ö·û¼¯£¬Ò»¸öÊÇ5.0.18¿ªÊ¼µÄĬÈÏstrict mode¡£
¶ÔÓÚÕâÁ½¸öÎÊÌ⣬ЧÂÊ×îºÃµÄ½â¾ö·½°¸£¬¾ÍÊÇÖ±½ÓÐÞ¸Ämy.ini
# The default character set that will be u ......
--²éѯ¸¸µ¥Î»µÄº¯Êý
CREATE Function GetParentUnit(@UnitId bigint, @Level int)
Returns @Parents Table([UnitId] int ,[UnitName] nvarchar(64),[ParentUnitId] int)
As
Begin
If @Level < 1 ......
SQL Server Ë÷Òý½á¹¹¼°ÆäʹÓã¨Èý£©
×÷Õߣºfreedk
Ò»¡¢ÉîÈëdz³öÀí½âË÷Òý½á¹¹
¶þ¡¢¸ÄÉÆSQLÓï¾ä
ʵÏÖСÊý¾ÝÁ¿ºÍº£Á¿Êý¾ÝµÄͨÓ÷ÖÒ³ÏÔʾ´æ´¢¹ý³Ì
¡¡¡¡½¨Á¢Ò»¸ö Web Ó¦Ó㬷ÖÒ³ä¯ÀÀ¹¦Äܱز»¿ÉÉÙ¡£Õâ¸öÎÊÌâÊÇÊý¾Ý¿â´¦ÀíÖÐÊ®·Ö³£¼ûµÄÎÊÌâ¡£¾µäµÄÊý¾Ý·ÖÒ³·½·¨ÊÇ:ADO ¼Í¼¼¯·ÖÒ³·¨£¬Ò²¾ÍÊÇÀûÓÃADO×Ô´øµÄ·ÖÒ³¹¦ÄÜ£¨ÀûÓÃÓα꣩À ......
create function [dbo].[DeptTree](@initDeptCode varchar(10))/*¶¨Ò庯Êýc_tree£¬ÊäÈë²ÎÊýΪ³õʼ½ÚµãDeptCode*/
returns @t table(DeptCode varchar(10),UpDeptCode varchar(10),lev int)/*¶¨Òå±ítÓÃÀ´´æ·ÅÈ¡³öµÄÊý¾Ý*/
begin
declare @i int/*±êÖ¾µÝ¹é¼¶±ð*/
set @i=1
insert @t ......