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

ÓÃ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µÄÊý¾Ý¿â.  »¹²»ÖªµÀÔ­À´´íÎó³öÔÚÄĶùÁËÄØ???? ÔٺúÃÏëÏë.

¶àл¸÷λÁË.


Ïà¹ØÎÊ´ð£º

×Ü»áÅöµ½¹ÖµÄÎÊÌ⣬sqlÎÊÌâ

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  ......

sqlÓï¾äÖÐÄܲ»ÄÜÕâÑùÅÅÐò£¿

Êý¾Ý±í¡¾biao¡¿£¬
×ֶΣºid¡¢myname¡¢mytxt
mytxtÄÚÈݸñʽÐÎÈ磺n|abcd¡££¨ÀýÈ磺1|ÁõµÂ»ª£¬2|Èδﻪ£¬3|αÌϼ£¬4|Âõ¿Ë@½Ü¿ËÑ·£©

ÎÒÏÖÔÚÏ£Íû¶Á¼Ç¼³öÀ´ºó£¬°´ÕÕ[mytxt]×Ö¶ÎÀïµÄÊúÏߣ¨|£©Ç°ÃæµÄÄǸöÊý× ......

ÇóÒ»¸ösql Óï¾ä

  table1
  Ãû³Æ      Èë¿âÊý
  CT»ú        3   
  CT»ú        5
  X¹â»ú      4 ......

²»Ã÷°×µÄSQL×¢ÈëÎÊÌâ

ÎÒÊý¾Ý¿âÊÇMSSQLµÄ£¬×òÌìËùÓÐµÄ±í±»×¢ÈëJS½Å±¾´úÂë,Óиö²»Ã÷°×µÄµØ·½À´ÎÊÎÊ´ó¼Ò

ÎÒ·¢ÏÖÓÐЩ±íÎÒ¸ù±¾Ã»Ê¹Óã¬Ò²Ã»ÓÐÈë¿âµÄASPÒ³ÃæºÍÓï¾ä£¬ËüÊÇÔÛ¸ö×¢ÈëµÄÄØ£¿
Ã²ËÆselectÓï¾äÊÇ¿ÉÒÔǶÌ׵İɣ¿
¿ÉÄÜÊÇwhere ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ