ÓÃSQL Server 2005´´½¨Êý¾Ý¿âʧ°Ü...
ÓÃSQL Server 2005´´½¨Êý¾Ý¿â "new"³öÏÖ´íÎó:
±êÌâ: Microsoft SQL Server Management Studio
------------------------------
´´½¨ ¶ÔÓÚ Êý¾Ý¿â¡°new ¡±Ê§°Ü¡£ (Microsoft.SqlServer.Smo)
ÆäËûÐÅÏ¢:
Ö´ÐÐ Transact-SQL Óï¾ä»òÅú´¦Àíʱ·¢ÉúÁËÒì³£¡£ (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ÎÞ·¨»ñµÃÊý¾Ý¿â 'model' ÉϵÄÅÅËûËø¡£ÇëÉÔºóÖØÊԸòÙ×÷¡£
CREATE DATABASE ʧ°Ü¡£ÎÞ·¨´´½¨ÁгöµÄijЩÎļþÃû¡£Çë²é¿´Ïà¹Ø´íÎó¡£ (Microsoft SQL Server£¬´íÎó: 1807)
Ôõô»ØÊÂ?Çë¸ßÊÖÖ¸µã.
Óï¾äÄØ£¿new Êǹؼü×ÖµÃÔµ¹Ê£¿»¹ÊÇÒѾÓÐÕâ¸ö±íÁË£¿
ÄãÊÇÔõôдµÄ°¡?ÐèÒª¸ù¾ÝÄãдµÄ¶«Î÷²ÅÄÜÕÒµ½ÄãµÄÎÊÌâµã°¡
°ÑÄãдµÄ¶«Î÷Ìù³öÀ´¿´¿´£¡²»È»¹íÖªµÀÕ¦ÁË£¡ÊDz»ÊÇÄãµÄÓï·¨ÓôíÁË!»¹ÊÇ£¿£¿£¿£¿
·ÅÊý¾Ý¿âÎļþµÄĿ¼ÓÐûÓУ¿
´ò¿ªSQL Server 2005ºó,Ñ¡ÔñÊý¾Ý¿â,ÓÒ¼üн¨Êý¾Ý¿â,µ¯³ö¶Ô»°¿ò,ÊäÈëÊý¾Ý¿âÃûΪnew.¾Í³öÏÖÁËÈçÉϵĴíÎó.
½ñÌìÓÖÖØÐÂÊÔÁËÊÔ,´íÎóûÁË,¿ÉÒÔ½¨³ÉÃûΪnewµÄÊý¾Ý¿â. »¹²»ÖªµÀÔÀ´´íÎó³öÔÚÄĶùÁËÄØ???? ÔٺúÃÏëÏë.
¶àл¸÷λÁË.
Ïà¹ØÎÊ´ð£º
sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and ......
Êý¾Ý±í¡¾biao¡¿£¬
×ֶΣºid¡¢myname¡¢mytxt
mytxtÄÚÈݸñʽÐÎÈ磺n|abcd¡££¨ÀýÈ磺1|ÁõµÂ»ª£¬2|Èδﻪ£¬3|αÌϼ£¬4|Âõ¿Ë@½Ü¿ËÑ·£©
ÎÒÏÖÔÚÏ£Íû¶Á¼Ç¼³öÀ´ºó£¬°´ÕÕ[mytxt]×Ö¶ÎÀïµÄÊúÏߣ¨|£©Ç°ÃæµÄÄǸöÊý× ......
table1
Ãû³Æ Èë¿âÊý
CT»ú 3
CT»ú 5
X¹â»ú 4 ......
ÎÒÊý¾Ý¿âÊÇMSSQLµÄ£¬×òÌìËùÓÐµÄ±í±»×¢ÈëJS½Å±¾´úÂë,Óиö²»Ã÷°×µÄµØ·½À´ÎÊÎÊ´ó¼Ò
ÎÒ·¢ÏÖÓÐЩ±íÎÒ¸ù±¾Ã»Ê¹Óã¬Ò²Ã»ÓÐÈë¿âµÄASPÒ³ÃæºÍÓï¾ä£¬ËüÊÇÔÛ¸ö×¢ÈëµÄÄØ£¿
Ã²ËÆselectÓï¾äÊÇ¿ÉÒÔǶÌ׵İɣ¿
¿ÉÄÜÊÇwhere ......