MSSQL 2005 Êý¾Ý¿â»Ö¸´Ê§°Ü
²»ÖªµÀÊÇʲôÔÒòʧ°ÜÁË
ÈçÏÂͼËùʾ£º
Èç¹ûͼƬ˵µÁÁ´¿ÉÒÔ½øÈëÒÔÏÂÁ´½Ó£º
http://hiphotos.baidu.com/z789017890/pic/item/890d6cf0c6996482a40f5282.jpg
ÏȸÐлÄãµÄ°ïÖú~~
Á´½ÓÒ²µÁÁ´ÁË.
ͼƬ¿´²»µ½Âð£¿
Á´½ÓÀïÃæµÄͼƬºÍÕâÀïµÄͼƬһÑù Â¥Ö÷¿ÉÒÔ¶àÇõã×Ö˵Ã÷ϾÍÐÐÁË
¿´²»µ½.Ö»ÔÊÐí°Ù¶ÈÓû§Ê¹ÓÃ.
Ö÷ÒªÓÉÓÚн¨µÄÊý¾ÝÓ뱸·Ý¼¯ÖеIJ»Í¬µ¼ÖÂ
½â¾ö°ì·¨£º
Ñ¡Ïî¡¡£££¾Ç¿ÖÆ»¹ÔÊý¾Ý¿â¹´ÉÏ
££>»¹ÔÑ¡Ïî¡¡£££¾¸²¸ÇÏÖÓÐÊý¾Ý¿â¡¡£££¾¡¡È·¶¨
ÌáʾÓÐÈçÏÂÎÄ×Ö£º
system.data.sqlclient.sqlerror±¸·Ý¼¯ÖеÄÊý¾Ý¿â±¸·ÝÓëÏÖÓеġ°XX¡±Êý¾Ý¿â²»Í¬.
(Microsoft.sqlserver.smo)
ÎÒ½¨Á¢µÄÊý¾Ý¿âÃûÓëËù±¸·ÝµÄÎļþµÄÎļþÃûÊÇÒ»ÖµÄ
µ«ÊDz»ÖªµÀΪʲô»Ö¸´²»ÁË¡«¡«
ллÁË
Ì«¾Ãû¸ãÊý¾Ý¿â·½ÃæµÄ¶«Î÷
Íü¼ÇÁË
Ïà¹ØÎÊ´ð£º
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] δ·¢ÏÖÊý¾ÝÔ´Ãû³Æ²¢ÇÒδָ¶¨Ä¬ÈÏÇý¶¯³ÌÐò, SQL state IM002 in SQLConnect in D:\0\msc\msc\tel.php on line 44
Í ......
ʹÓÃjavaÔÚwindows7 32λÏÂÁ¬½ÓMSSQL¡£
Á½Ì¨»úÆ÷£¬windows7 32룬ÔÚ¿ØÖÆÃæ°åÀïÃæÈ«²¿ÉèÖÃÓïÑÔºÍÇøÓòÑ¡Ïî¶¼english-unitedstates
Î¨Ò»Çø±ðÖ»ÓÐÔÚ°²×°SQL server 2008µÄʱºò Ñ¡ÔñµÄ×Ö·û¼¯²»Ò»Ñù£¬
exec sp_helpsor ......
ÎÒ½¨Á¢ÀàËÆÕâÑùµÄ´æ´¢¹ý³Ì
SQL code:
CREATE PROCEDURE pro
@var sysname
AS
if @var='a'
select * into #mb from mb
else if @var= 'b'
select * into #mb from mb
Ìáʾ´íÎó2714:Êý¾Ý¿âÖÐÒÑ ......