ms sqlserver 08 Ô¶³ÌÁ¬½Ó
ÎÒ°²×°µÄ08°æ±¾ÊÇEnterprise£¬µ±ÎÒÔ¶³ÌÁ¬½Óʱ¿ÉÒÔ½øÈëµÇ½Óû§£¬µ«¾ÍÊDZéÀú²»ÁËÊý¾Ý¿â£¨Ìáʾ¸ÃÓû§ÔÚµ±Ç°°²È«ÉèÖÃϲ»¿ÉÒÔ·ÃÎÊÄ¿µÄÊý¾Ý¿â£©£¡
È»¶øÎÒÈ¥ÆäËüµçÄÔÉÏÓøÃÓû§ÊÇ¿ÉÒԵǼºÍ±éÀúµÄ£¬ËµÃ÷¸ÃÓû§µÄȨÏÞÊÇÓеġ£ÎÒfirewallÒ²¿ªÁË1433µÄ¶Ë¿Ú tcp/ipÒ²ÉèÖÃÁË£¬½á¹û»¹ÊDz»ÐУ¡
Çë¸÷λ°ëÊÞÈ˸ø½â¾ö·½°¸£¬Ð»Ð»ÁË£¡
ûÈ˻شðÂð£¿ÄÇÔõô½áÌù...
Ò²³¢ÊÔ´ò¹ý £¬²»¹ý´ò²»ÉÏ
Ò»¶¨µÃ´òsp1²¹¶¡Âð£¿
½¨Òé´òÉÏÊÔÊÔ
ËüµÄ´íÎóÈÕÖ¾ ÎÒÓе㿴²»¶®£¬ÇëÄú¿´Ï塃 ¼ÓMSN°É
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
ÏÖÔÚÎҵı¾»úÊÇÓõÄsqlserver2000°æ±¾µÄ(¿ÉÒÔÕý³£µÄÁ¬½Ó)¡£Êý¾ÝÁ¬½ÓÈçÏ£ºproxool.xml
XML code:
<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
......
´ÓÍøÉϲ鵽µÄ×ÊÁÏ˵£¬ÈκÎÊý¾ÝÀàÐÍÓëNULLÖµ½øÐмÆË㣬½á¹û¶¼½«ÎªNULL.
select null-1
½á¹ûÊÇnull
¿ÉÊÇÏÂÃæÕâ¸ö²éѯΪʲô»á³ö´íÄØ£¿
select isnull(null-1,'test');
¾ÓÈ»±¨´í˵½«varcharתΪintʧ°Ü¡£
Ϊʲô» ......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......
ÔÚmysqlÀïÓжÁËø Ð´Ëø
ÊÇÕâÑùÉèÖõÄ
lock tables a write££££££Ð´Ëø
------ÄãµÄsqlÓï¾ä
unlock tables
ÏëÖªµÀ ÔÚsqlserver2005ÀïÓÐûÓжÔÓ¦µÄÓï¾äд£¿ £¨Ò²¾ÍÊÇ Èçº ......