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

sqlserver Õ¼ÓÃÄÚ´æÌ«¸ßÔõô½â¾ö?

sqlserver  Õ¼ÓÃÄÚ´æÌ«¸ßÔõô½â¾ö?
sqlserver 2000 sp4,xp ϵͳ£¬ÎÒ×Ô¼ºµÄ»ú×ÓÊÇ¿ª·¢»ú£¬Õ¼ÓÃÄÚ´æÌ«¸ßÁË£¬»ú×Ó·´Ó¦Âý£¬ÇëÎÊÓÐûÕë¶Ô¿ª·¢µÄÅäÖã¬ÈÃsqlserverÔÚºǫ́ÅÜÆðÀ´µÄʱºòÕ¼ÓÃÄÚ´æÉÔ΢Сһµã¡£Èç¹ûÓÐÓ¦¸ÃÔõôÅäÖÃÄØ£¿
¹ØÓÚÎ޹ؽø³Ì£¬Í£Ö¹Î޹طþÎñ¡£

ÄÚ´æ±ãÒË¡£¼Ó

ÇëÎÊÄÚ´æ¶à´ó£¿ÉèÖÃÐéÄâÄÚ´æÃ»ÓУ¿

1¡¢ÄãµÄSQLʲô°æ±¾µÄ£¿
2¡¢¼ÓÄÚ´æÊDZØÐëµÄÒ²ÊÇ×î¿ÉÐеġ£

ÉèÖÃÐéÄâÄÚ´æÒ²¿ÉÒÔ¿¼ÂÇ¡£

¹ØµôһЩ·þÎñÖ»Äܽâ¾öÎÊÌâ°É£»»¹ÊÇÖ»ÓмÓÄÚ´æ²ÅÊÇÍõµÀ

Õ¼Óöà´óµÄÄÚ´æÁË£¿
¼ÓÄÚ´æ°É

µ÷ÓÅÒ»ÏÂ
²é²éÊÇÄÚ´æÄÚ²¿Ñ¹Á¦»¹ÊÇÍⲿѹÁ¦

ÔÙÕÒ³öÏà¶ÔÓ¦µÄ½â¾ö·½°¸

²»ÏëÔö¼ÓÄÚ´æµÄ»°£º
¹ØµôMSDTS,¹ØµôSQL AGENT£¬¹ØµôÈ«ÎÄËÑË÷·þÎñ£¬Ôö¼ÓÐéÄâÄÚ´æ²¢·Åµ½±ðµÄ·ÖÇø£¬·ÖÇø´ÅÅÌÕûÀí¡£

CF

µÚÒ»²½:´ò¿ªÆóÒµ¹ÜÀíË«»÷½øÈëÒªÐ޸ĵÄMSSQL.

µÚ¶þ²½:ÔÚ×ó²àMSSQLÉϵã»÷ÓÒ¼ü,Ñ¡ÔñÊôÐÔ,µ¯³öSQL ServerÊôÐÔ(ÅäÖÃ)¶Ô»°¿ò

µÚÈý²½:µã»÷ÄÚ´æÑ¡Ï.

ÔÚÕâÀï,Äã»á¿´µ½MSSQLĬÈÏÉèÖÃΪʹÓÃ×î´óÄÚ´æ,Ò²¾ÍÊÇÄãËùÓеÄÄÚ´æ,¸ù¾ÝÄãµÄÐèÒª,ÉèÖÃËüµÄ×î´óÖµ°É.

µÚÎå²½:ÉèÖÃÍê±Ï,ÖØMSSQL·þÎñ,ÅäÖü´¿ÉÉúЧ!


Ôö¼ÓÄÚ´æÊDz»´íµÄÑ¡Ôñ

SQL Õ¼ÓÃÄÚ´æÊÇ·ÖÁ½²¿·ÖµÄ£¬Ò»²¿·ÖÊÇ¿ÉÒÔSQL ÊôÐÔ£¬ÄÚ´æÖÐÅäÖõ쬵«ÊÇÕⲿ·ÖÖ»ÊÇÕë¶Ô»º´æµÄÅäÖã¬ÁíÍâÒ»²¿·Ö±ÈÈçSQL ½øÐÐÁ¬½Ó¡¢¼ÆËãµÈËùʹÓõÄÄÚ´æ²¢²»ÊÇÊڿصģ¬ËùÒÔ£¬Èç¹ûÈ·ÈÏÊÇÄÚ´æ²»×ãΨһ¸öµÄ°ì·¨¾Í¼ÓÄڴ棬Èç¹ûÄÚ´æ×ã¹»£¬ÄǾÍÒª¼ì²éÊDz»ÊÇ»º´æÅäÖõÄÌ«ÉÙÁË¡£

ÏÈ´ÓÓ²¼þÅäÖÃÈëÊÖ£¬ÄÚ´æ¸ú°×²ËÒ»Ñù¡£


ÓÃOracleÕ¼ÓÃÄÚ´æ¾Í²»»áÌ«¸ß

ÎÒµÄÊÇxpϵͳ£¬5


Ïà¹ØÎÊ´ð£º

ÔÚ64λϵͳÉÏÓÃCÓïÑÔ²Ù×÷sqlserverÊý¾Ý¿âµÄÎÊÌâ

дÁËÒ»¸öÓÃCÓïÑÔ²Ù×÷sqlserverÊý¾Ý¿âµÄ³ÌÐò£¬ÔÚÎÒ×Ô¼ºµÄ¼ÆËã»úÉÏÔËÐÐûÎÊÌâ¡£µ«µ½Áíһ̨»úÆ÷ÉÏÔËÐÐʱ£¬SQLConnectº¯ÊýÁ¬½ÓÊý¾Ý¿âʧ°Ü£¬×Ðϸ¼ì²éÉèÖö¼Ã»Óз¢ÏÖÎÊÌ⣬µ«¸Ã»úÆ÷µÄ²Ù×÷ϵͳÊÇWindows Server 2003 Enterp ......

SQLSERVER 2000 ÔÚ RAID·þÎñÆ÷ÉÏ£¬¸ÃÈçºÎÅäÖã¿

ÏÖÒ»·þÎñÆ÷£¬Ö§³ÖRAID5/RAID1+0µÈ£¬ÓÐ4¿éÒ»ÑùÐͺŵÄÓ²ÅÌ£¬°²×°ÁËRAID¿¨¡£

ÎÒËÑË÷ÁËÂÛ̳£¬ÓÐ˵Ҫ°ÑÊý¾Ý¿âÎļþ·Ö²¼ÔÚ²»Í¬´ÅÅÌ£¬µ«ÊÇ£¬×öraid5»òraid10ºó£¬4¿éÓ²Å̺ÃÏñ³ÉΪһÌåÁË£¬ÎÒ·Ö3¸ö·ÖÇø£¬Îļþ·Ö²¼ÔÚ²»Í¬· ......

200·ÖÇó´´½¨ÁÙʱ±í£¨sqlserver£©

±ÈÈçsqlÓï¾äÊÇ£º
SQL code:

select top 300
CA01.A_id as '±ä¶¯´ÎÊý',
CA01.A0188 as 'ÈËÔ±id',
CA01.apname as 'ÉóÅúÕß',
CA01.CA0100 as 'È·ÈÏ״̬',
CA01.CA0101 as '±ä¶¯ÀàÐÍ',
CA01.CA0102 as 'Éê ......

sqlserver ´¥·¢Æ÷ÎÊÌâ

ÎÒÏë×öÒ»¸ö´¥·¢Æ÷£¬µ«Ð޸ıíTµÄ×Ö¶ÎC1ʱ£¬ÅжÏÈç¹ûÐ޸ĺóµÄֵΪ-1£¬Ôò¸üбíT¸ÃÐмǼµÄ×Ö¶ÎC2Ϊijֵ¡£

CreateTRIGGER [Tri_UpdateLastSaveDate] ON  [dbo].[T]
  for UPDATE
AS
BEGIN ......

sqlserver ÈçºÎµ÷ÊÔ´æ´¢¹ý³Ì

sqlserverÓÐûÓÐÏóoracleÄÇÑù¿ÉÒÔtest´æ´¢¹ý³Ì ,µ¥²½µ÷ÊÔ.²»Ó¦¸ÃûÓаÑ,ÎÒÔõôûÕÒµ½ÄØ? Òª²»È»ÉÔ΢³¤µãµÄ´æ´¢¹ý³ÌÔõôµ÷ÊÔÄØ?
ºÃÏóûÓÐ.

ûÓаÉ

ÓУ¬²éѯ·ÖÎöÆ÷ÖÐÓÒ¼ü´æ´¢¹ý³Ì£¬µ¥²½µ÷ÊÔ

°Ù¶ÈÉÏÈ¥ÕÒһϠ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ