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

sql server 2005 ÅäÖÃÔ¶³ÌÁ¬½Ó

ÒÔÏÂ˵Ã÷¾ùÕë¶ÔÆóÒµ°æ»òÕß¿ª·¢°æ£»
1.¿ªÆôsql server ʵÀýµÄÔ¶³ÌÁ¬½Ó£»
    “¿ªÊ¼”-->“³ÌÐò”-->“Microsoft SQL Server 2005”-->“ÅäÖù¤¾ß”-->“SQL Server ÍâΧӦÓÃÅäÖÃÆ÷”-->“·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷”-->“Êý¾Ý¿âÒýÇæ”-->"Ô¶³ÌÁ¬½Ó"-->“±¾µØÁ¬½ÓºÍÔ¶³ÌÁ¬½Ó”-->µ¥»÷ÊÊÓÃÓÚÄúµÄ»·¾³µÄÏàӦЭÒé(½öʹÓÃtcp/ip)
2.¿ªÆôSQL Server Browser·þÎñºÍSQL Server Agent ·þÎñ
     ¿ØÖÆÃæ°å-->¹ÜÀí¹¤¾ß-->·þÎñ-->Æô¶¯¸Ã¸ÃÁ½¸ö·þÎñ
3.¹Ø±Õ·À»ðǽ£¨Ò²¿ÉÒÔÅäÖã©£¬ÅäÖüûÏÂÎÄ¡£
http://support.microsoft.com/kb/914277/zh-cn


Ïà¹ØÎĵµ£º

c# ²Ù×÷mssqlÊý¾Ý¿â º¬Óдø²ÎÊýsqlÓï¾äÔËÐÐ

<?xml version="1.0" encoding="utf-8"?>
<configuration>
 <appSettings>
  <add key="Default" value="Default" />
 </appSettings>
 <connectionStrings>
  <add name="Default" connectionString="Data Source=192.168.1.197;User ID ......

ºØÖÝÊм²²¡Ô¤·À¿ØÖÆÖÐÐÄSQL serverÊý¾Ý¿âÖÃÒɳɹ¦ÐÞ¸´

ºØÖÝÊм²²¡Ô¤·À¿ØÖÆÖÐÐÄËùÓõÄZmSoft´ÓÒµÌå¼ìÐÅÏ¢ÍøÂçϵͳV2010.1.26 Õýʽ°æ²ÉÓÃSQL SERVER2000ƽ̨,²»Ã÷Ô­Òò,Êý¾Ý¿â"ÖÃÒÉ“,¿Í»§ÊÔ¹ýËùÓÐÍøÉÏ·½·¨,δÄܽâ¾ö.ÉòÑô¿­ÎÄÊý¾Ý»Ö¸´ÖÐÐÄSQLÊý¾Ý¿â¹¤³Ìʦ³É¹¦½«Æä½â¾ö.
ÉòÑô¿­ÎÄÊý¾Ý»Ö¸´ÖÐÐÄMS SQL SERVERÑз¢Ð¡×éÖÂÁ¦ÓÚMsSqlÊý¾Ý¿â¼¼ÊõµÄÑо¿¡£¾­¹ý¶àÄêÑо¿ÍêÈ«ÕÆÎÕÁËS ......

SQLÖÐ CAST Óë CONVERTת»¯º¯ÊýµÄÓ÷¨

 ½«Ä³ÖÖÊý¾ÝÀàÐ͵ıí´ïʽÏÔʽת»»ÎªÁíÒ»ÖÖÊý¾ÝÀàÐÍ¡£CAST ºÍ CONVERT ÌṩÏàËÆµÄ¹¦ÄÜ¡£
Óï·¨
ʹÓà CAST£º
CAST ( expression AS data_type )
ʹÓà CONVERT£º
CONVERT (data_type[(length)], expression [, style])
²ÎÊý
expression
ÊÇÈκÎÓÐЧµÄ Microsoft® SQL Server™ ±í´ïʽ¡£Óйظü¶àÐÅÏ¢£¬Çë² ......

SQLÓαê¿ìËÙÉÏÊÖ

ÎÊÌâÃèÊö£ºÓÐÒÔÏÂ2ÕÅ±í£¬
     ±íA
     0_id           0_name      0_Salary
   Y2007001     ´ï¸ç         &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ