SQL server 1068´íÎó
ÏÖÏó£º
ÎҵĵçÄÔ--¹ÜÀí--·þÎñ--mssqlserver ·þÎñ --Æô¶¯
±¨´í£¬1068£¬
»òÕߣ¬sqlserver ÅäÖùÜÀíÆ÷ÖÐSqlServer Ö÷·þÎñÆô¶¯ ±¨´í Ìáʾ˵ÒÀ´æµÄ·þÎñ»òÕß×é¼þûÓÐÆô¶¯£¬
ÔÒò£ºÎÒÊDzËÄñ£¬²»Ì«Àí½âµ½µ×ʲôÔÒò£¬µ«ÊÇÕÒµ½Á˽â¾ö·½·¨
½â¾ö·½·¨£º
SqlServer ÅäÖùÜÀíÆ÷--SqlServer native client--¿Í»§¶ËÐÒé--via ÓÒ¼ü ½ûÓõô¡£
ÖØÆôÆô¶¯ SqlServer ·þÎñ ok
Ïà¹ØÎĵµ£º
ÔÚ¼¤ÁÒµÄÊг¡¾ºÕù»·¾³Ï£¬ÉÌÈ˶ÔÊг¡»·¾³µÄ°ÑÎպ;ö²ßÖ±½Ó¹ØÏµµ½Êг¡µÄÇ÷ÊÆºÍ»úÓö£¬¶Ô¿Í»§ÐèÇóµÄ¿ìËÙÏàÓ¦Äܹ»Õ¼¾¡Êг¡µÄÏÈ»ú¡£ÔÚµ±½ñÉç»áµÄÈÕ³£ÉÌÎñ»î¶¯ÖУ¬ÒÔÍù»ýÀÛµÄÏà¹ØÉÌÒµÊý¾ÝÄܹ»ÎªºóÐøµÄÒµÎñ»î¶¯ÌṩÁ¼ºÃµÄ²Î¿¼ºÍÏòµ¼¡£ÔçÔÚ10ÓàÄêǰ£¬ÉÌÒµÖÇÄÜ£¨Business Intelligence£¬Ï³ÆBI£©³§É̾ÍÒѾ ......
ÎÒÔÚ½«ExcelµÄÊý¾Ýµ¼Èëµ½SQLµÄʱºòÀÏÊdzöÏÖÏÂÃæµÄ´íÎó£º
ÅäÖÃÑ¡Ïî 'show advanced options' ÒÑ´Ó 1 ¸ü¸ÄΪ 1¡£ÇëÔËÐÐ RECONFIGURE Óï¾ä½øÐа²×°¡£
ÅäÖÃÑ¡Ïî 'Ad Hoc Distributed Queries' ÒÑ´Ó 1 ¸ü¸ÄΪ 1¡£ÇëÔËÐÐ RECONFIGURE Óï¾ä½øÐа²×°¡£
ÏûÏ¢ 7399£¬¼¶±ð 16£¬×´Ì¬ 1£¬µÚ 1 ÐÐ
Á´½Ó·þÎñÆ÷ "(null)" µÄ OLE DB ·ÃÎÊ ......
±¾ÎÄÀ´×Ô£º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 ±êÊ ......
±¾ÎÄת×Ô£ºhttp://industry.ccidnet.com/art/1106/20070514/1080519_1.html
±¾ÎÄÊÇSQL Server SQLÓï¾äÓÅ»¯ÏµÁÐÎÄÕµĵÚһƪ¡£¸ÃϵÁÐÎÄÕÂÃèÊöÁËÔÚMicosoft’s SQLServer2000¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳÖÐÓÅ»¯SELECTÓï¾äµÄ»ù±¾¼¼ÇÉ£¬ÎÒÃÇÌÖÂ۵ļ¼ÇÉ¿ÉÔÚMicrosoft's SQL Enterprise Manager»ò Microsoft SQL Query Anal ......