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

sqlÉú³É½Å±¾ÀïSET ANSI_NULLS ONʲôÒâ˼

±¾ÎÄÀ´×Ô£ºhttp://zhidao.baidu.com/question/27978123.html?si=1
ÕâЩÊÇ SQL-92 ÉèÖÃÓï¾ä£¬Ê¹ SQL Server 2000/2005 ×ñ´Ó SQL-92 ¹æÔò¡£
µ± SET QUOTED_IDENTIFIER Ϊ ON ʱ£¬±êʶ·û¿ÉÒÔÓÉË«ÒýºÅ·Ö¸ô£¬¶øÎÄ×Ö±ØÐëÓɵ¥ÒýºÅ·Ö¸ô¡£µ± SET QUOTED_IDENTIFIER Ϊ OFF ʱ£¬±êʶ·û²»¿É¼ÓÒýºÅ£¬ÇÒ±ØÐë·ûºÏËùÓÐ Transact-SQL ±êʶ·û¹æÔò¡£
SQL-92 ±ê×¼ÒªÇóÔÚ¶Ô¿ÕÖµ½øÐеÈÓÚ (=) »ò²»µÈÓÚ (<>) ±È½ÏʱȡֵΪ FALSE¡£µ± SET ANSI_NULLS Ϊ ON ʱ£¬¼´Ê¹ column_name Öаüº¬¿ÕÖµ£¬Ê¹Óà WHERE column_name = NULL µÄ SELECT Óï¾äÈÔ·µ»ØÁãÐС£¼´Ê¹ column_name Öаüº¬·Ç¿ÕÖµ£¬Ê¹Óà WHERE column_name <> NULL µÄ SELECT Óï¾äÈԻ᷵»ØÁãÐС£
µ± SET ANSI_NULLS Ϊ OFF ʱ£¬µÈÓÚ (=) ºÍ²»µÈÓÚ (<>) ±È½ÏÔËËã·û²»×ñ´Ó SQL-92 ±ê×¼¡£Ê¹Óà WHERE column_name = NULL µÄ SELECT Óï¾ä·µ»Ø column_name Öаüº¬¿ÕÖµµÄÐС£Ê¹Óà WHERE column_name <> NULL µÄ SELECT Óï¾ä·µ»ØÁÐÖаüº¬·Ç¿ÕÖµµÄÐС£´ËÍ⣬ʹÓà WHERE column_name <> XYZ_value µÄ SELECT Óï¾ä·µ»ØËùÓв»Îª XYZ_value Ò²²»Îª NULL µÄÐС£


Ïà¹ØÎĵµ£º

SQL SERVER2008Êý¾ÝÍÚ¾ò


¸ÅÊö
Microsoft SQL Server 2008 ÈÃÄúÄܹ»Í¨¹ýÖ±¹ÛµÄÊý¾ÝÍÚ¾òµÄÔ¤²âÐÔ·ÖÎöÀ´×ö³öÃ÷ÖǺÏÀíµÄ¾ö²ß£¬ÎÞ·ìµØÕûºÏ Microsoft ÉÌÒµÖÇÄÜÆ½Ì¨²¢¿ÉÀ©Õ¹ÖÁÉÌÒµÓ¦ÓóÌÐò¡£
ÖØ´óµÄй¦ÄÜ
ͬʱÀûÓôíÎóºÍ¾«È·¶ÈµÄͳ¼Æ·ÖÊýÀ´²âÊÔ¶à¸öÊý¾ÝÍÚ¾òÄ£ÐÍ£¬²¢ÀûÓý»²æÑéÖ¤À´È·ÈÏÆäÎȶ¨ÐÔ
ÔÚµ¥Ò»½á¹¹Öн¨Á¢¶à¸ö²»¼æÈݵÄÍÚ¾òÄ£ÐÍ¡¢ÔÚɸѡ¹ýµÄÊ ......

SQl 2005 For XMl ¼òµ¥²éѯ(Raw£¬Auto£¬Pathģʽ)(2)

ÎÄÕµ¼º½ SQL Server 2005 ѧϰ±Ê¼ÇϵÁÐÎÄÕµ¼º½
     ÔÚSQl 2005 For XMl ¼òµ¥²éѯ(Raw£¬Auto£¬Pathģʽ)(1) ÀïÎÒÃÇ˵Á˹ØÓÚPath£¬RawºÍAutoģʽµÄÓ÷¨£¬ÆäʵÀïÃæ²»½ö½ö ÊÇÕâЩ¼òµ¥µÄ²Ù×÷£¬»¹ÓÐһЩÆäËüµÄÌØÐÔ£¬±ÈÈç˵Type»òOpenXml·½·¨£¬sp_xml_preparedocument´æ´¢¹ý³Ì µÈÕâЩÔö¼ÓµÄ¶«¶«£¬ÎÒÃÇÀ´Ò» ......

SQL ×Ö·û´®º¯ÊýС×ܽá

Á·ÊÖ£¬Ã¿Ìì²é¿´±ðÈ˵Ķ«Î÷£¬²»Èç×Ô¼º×ܽáºÃ
1:replace º¯Êý
µÚÒ»¸ö²ÎÊýÄãµÄ×Ö·û´®£¬µÚ¶þ¸ö²ÎÊýÄãÏëÌæ»»µÄ²¿·Ö£¬µÚÈý¸ö²ÎÊýÄãÒªÌæ»»³Éʲô
select replace('lihan','a','b')
                      &nb ......

¹ØÓÚSQL Server·þÎñ¹ÜÀíÆ÷µÄÎÊÌâ

ÎÊÌâ: һ̨·þÎñÆ÷ÉÏÔËÐÐÁËSQL Server,SQL Server Agent,Distributed Transaction,CoordinatorÕâÈý¸ö·þÎñ£¬ÇëÎÊÕą̂·þÎñÆ÷ÊÇһ̨ʲôÑùµÄ·þÎñÆ÷£¿ÕâÈý¸ö·þÎñ¾ßÌåÓÐʲô×÷Óã¿
ÕâÊÇһ̨Êý¾Ý¿â·þÎñÆ÷.
SQL Server ÕâÊÇÖ÷Êý¾Ý¿â·þÎñ£¬¶øÇÒÐγÉÁËSQL ServerµÄÖ§Öù¡£ËüÓÃÓÚ´æ´¢ºÍÌáÈ¡Êý¾Ý¡£
SQL Server Agent Ò²½ÐSQL Server´ú ......

½«ExcelµÄÊý¾Ýµ¼Èëµ½SQL 2005ÏÖÓеıíÖÐ

ÎÒÔÚ½«ExcelµÄÊý¾Ýµ¼Èëµ½SQLµÄʱºòÀÏÊdzöÏÖÏÂÃæµÄ´íÎó£º
ÅäÖÃÑ¡Ïî 'show advanced options' ÒÑ´Ó 1 ¸ü¸ÄΪ 1¡£ÇëÔËÐÐ RECONFIGURE Óï¾ä½øÐа²×°¡£
ÅäÖÃÑ¡Ïî 'Ad Hoc Distributed Queries' ÒÑ´Ó 1 ¸ü¸ÄΪ 1¡£ÇëÔËÐÐ RECONFIGURE Óï¾ä½øÐа²×°¡£
ÏûÏ¢ 7399£¬¼¶±ð 16£¬×´Ì¬ 1£¬µÚ 1 ÐÐ
Á´½Ó·þÎñÆ÷ "(null)" µÄ OLE DB ·ÃÎÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ