»òÐíÊÇSqlServer°²×°ÎÊÌâ..... Çó½Ì£¡
SqlServer°²×°µÄ¹ý³ÌÖУ¬ÊDz»ÊÇÓÐÒ»¸öÓòµÄÅäÖ㬷þÎñÆ÷Ãû³ÆÊ¹Óñ¾»ú¼ÆËã»úÃû³Æ£¿ ÊÇÕâÑùµÄ£¬ÓиöÓ¦ÓóÌÐò£¬½øÈëµÄʱºò¾ÍÌáʾ ÕÒ²»µ½·þÎñÆ÷£¬ ÎÒ¿´ÁËÆäËûµÄÅäÖ㬳ýÁËSqlServerµÄ°æ±¾²»Ò»ÑùÍ⣬¾ÍÊÇ·þÎñÆ÷µÄÃû³Æ£¬ÎÒÔÚ°²×°µÄ¹ý³ÌÖÐʹÓõÄÊÇĬÈÏ(local)£¬¶øÁ¬½Ó·þÎñÆ÷µÄÃû³ÆÊDZ¾»úµÄÃû³Æ¡£ÊÔÎÊÈçºÎÄܹ»Ð޸ĸÃSqlµÄ·þÎñÆ÷Ãû³Æ£¿ »¹ÊÇÓÐÆäËûµÄ·½ÃæµÄ´íÎó£¿ Ð»Ð»£¡£¡£¡
Ò»頭霧Ë®£¬幫頂¡£ Â¥Ö÷¸ø³öÊý¾Ý¿âÁ¬½Ó×Ö·û´®»¹ÓзþÎñÆ÷Ãû ÔÚSQL server°²×°ÖÐÓÐÑ¡ÔñÊDzÉÓÃÓòÓû§»¹ÊDZ¾µØ·½Ê½£¬Ò»°ã¶¼ÊÇÑ¡±¾µØµÄÒýÓà SqlServer°²×°µÄ¹ý³ÌÖУ¬ÊDz»ÊÇÓÐÒ»¸öÓòµÄÅäÖ㬷þÎñÆ÷Ãû³ÆÊ¹Óñ¾»ú¼ÆËã»úÃû³Æ£¿ ÊÇÕâÑùµÄ£¬ÓиöÓ¦ÓóÌÐò£¬½øÈëµÄʱºò¾ÍÌáʾ ÕÒ²»µ½·þÎñÆ÷£¬ ÎÒ¿´ÁËÆäËûµÄÅäÖ㬳ýÁËSqlServerµÄ°æ±¾²»Ò»ÑùÍ⣬¾ÍÊÇ·þÎñÆ÷µÄÃû³Æ£¬ÎÒÔÚ°²×°µÄ¹ý³ÌÖÐʹÓõÄÊÇĬÈÏ(local)£¬¶øÁ¬½Ó·þÎñÆ÷µÄÃû³ÆÊDZ¾»úµÄÃû³Æ¡£ÊÔÎÊÈçºÎÄܹ»Ð޸ĸÃSqlµÄ·þÎñÆ÷Ãû³Æ£¿ »¹ÊÇÓÐÆäËûµÄ·½ÃæµÄ´íÎó£¿ Ð»Ð»£¡£¡£¡ ÏÈPING·þÎñÆ÷¿´¿´Äܲ»ÄÜPINGͨ£¬ÔÙ¼ì²éÁ¬½Ó×Ö·û´®£¬ÔÙ²»Ðоͳ¢ÊÔ´ò²¹¶¡£¬ÔÙ²»Ðоͱ¸·ÝÒ»ÏÂÖØ×°Ò»±é¡£ SQL code: ÅäÖÃÎļþ²»¶Ô...ÒýÓà SQL code ÅäÖÃÎļþ²»¶Ô... ¿´ÆðÀ´£¬ÄãÊÇ×ö¹ýÀàËÆµÄ²Ù×÷£¬ ˵À´ÌýÌý£¬ÅäÖÃÎļþÎÒÒ²×öÁË£¬¾ø¶ÔûÓÐÎÊÌ⣡£¡£
Ïà¹ØÎÊ´ð£º
дÁËÒ»¸öÓÃCÓïÑÔ²Ù×÷sqlserverÊý¾Ý¿âµÄ³ÌÐò£¬ÔÚÎÒ×Ô¼ºµÄ¼ÆËã»úÉÏÔËÐÐûÎÊÌâ¡£µ«µ½Áíһ̨»úÆ÷ÉÏÔËÐÐʱ£¬SQLConnectº¯ÊýÁ¬½ÓÊý¾Ý¿âʧ°Ü£¬×Ðϸ¼ì²éÉèÖö¼Ã»Óз¢ÏÖÎÊÌ⣬µ«¸Ã»úÆ÷µÄ²Ù×÷ϵͳÊÇWindows Server 2003 Enterp ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð» ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡ ¹Ø×¢¡«¡« Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿ ......
´ó¼ÒºÃÏÖÔÚÓÐ Ò»¸öÎÞÏÞ¼¶·ÖÀà±í ÎÒÏë²éѯÈÎÒâÒ»¸ö·ÖÀàÏÂÃæËùÓеÄ×ÓÀࣨÎÞÏÞ¼¶µÄ£©¸ÃÈçºÎʵÏÖÄØ ÓÃÊ÷Óڽṹ http://blog.csdn.net/soft_wsx/archive/2009/09/04/4521091.aspx ½á¹¹£¬¼Ç¼ ......
ÏÂÃæÊÇÎÒµÄͳ¼ÆÐÅÏ¢£º ¿Í»§¶ËÖ´ÐÐʱ¼ä 10:28:48 ²éѯÅäÖÃÎļþͳ¼ÆÐÅÏ¢ INSERT¡¢DELETE ºÍ UPDATE Óï¾äµÄÊýÄ¿ 0 0.0000 INSERT¡¢DELETE »ò UPDATE Óï¾äÓ°ÏìµÄÐÐÊý 0 0.0000 ......
SqlServerÖÐ×Ö·ûÐÍת»»ÎªÊý×ÖÐͳöÏîµÄÎÊÌâ select @rno=rno from deleted; convert(numeric,@rno); @rno=@rno/1000; ÏûÏ¢ 156£¬¼¶±ð 15£¬×´Ì¬ 1£¬¹ý³Ì t2£¬µÚ 11 ÐÐ ¹Ø¼ü×Ö 'conve ......