Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 serverÊý¾Ý¿â,Êý¾Ýµ¼Èëµ¼³öÎÊÌâ

ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß

µ¼Èëµ¼³ö¹¤¾ß.

DD

¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä

Ö±½ÓÐ ......

sqlÎļþ£¨Êý¾Ýº¬ÖÐÎÄ£©DOSÃüÁî´°¿ÚÎÞ·¨µ¼ÈëÎÊÌâ

ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8

ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£

½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë

ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.

ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......

SQL×ֶΣ¬ºáÏòÕ¹¿ª

ÇëÎʸ÷룬ÈçºÎ½«SQlÖУ¬Ä³×Ö¶ÎÖеÄÖµºáÏòÕ¹¿ªÄØ£¬
CASE WHEN

¾ßÌåÎÊÌâ¾ßÌå·ÖÎö£¬¿´ÄãÒªÔõôչ¿ª

ÐÕÃû  ¿ÆÄ¿      ³É¼¨
ÕÅÈý  Ó¢Óï    90
ÀîËÄ  Ó¢Óï&nb ......

SQL ¶à±í²éѯ²é³öËùÒªµÄÊý¾Ý£¿

ÒÑÖª´ÓB,±íÖÐÕÒ³öID, NAMEÁ½ÏîÓëC±íÏàͬµÄÊý¾Ý£¬ÔÙÒÀ¾ÝB±íÖо­¹ý²éѯ³öÀ´µÄID,CODEÁ½ÏîÊý¾Ý²éѯÓëA±íID,CODEÁ½ÏîÏàͬµÄÊý¾ÝÖжÔÓ¦µÄEMAILÀ´£¬²¢ÁгöÈçÏÂD±íµÄÐÎʽ£¬²»ÖªÎÒÊÇ·ñ±íʾÇå³þ£¿Âé·³°ïÎÒÁÐһϹ«Ê½ºÃÂð£¿Íò· ......

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ