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

MSSQLÎÞ·¨Æô¶¯

===================================

ÎÞ·¨Á¬½Óµ½ .¡£

===================================

ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: ÃüÃû¹ÜµÀÌṩ³ÌÐò, error: 40 - ÎÞ·¨´ò¿ªµ½ SQL Server µÄÁ¬½Ó) (.Net SqlClient Data Provider)

------------------------------
ÓйذïÖúÐÅÏ¢£¬Çëµ¥»÷: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

------------------------------
´íÎóºÅ: 2
ÑÏÖØÐÔ: 20
״̬: 0


------------------------------
³ÌÐòλÖÃ:

  ÔÚ System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
  ÔÚ System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
  ÔÚ System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
  ÔÚ System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)


Ïà¹ØÎÊ´ð£º

MSSQL ²Ù×÷½á¹û¼¯

SQL code:
For Ls_desc IN (Select Di_ename ,Di_Pcs,Di_Unitprice
from T_BO_DeclareInvoice Di
WHERE bs_code = as_bs_code)
LOOP
IF Ls_desc.Di_ename IS ......

tadoqueryÔÚMSSQLÖÐÖ´Ðвéѯ£¬²ÎÊýÈçºÎ¸³Öµ£¿

ÈçÌ⣬²éѯÓï¾ä²ÎÊýÓ¦¸ÃÔõôд°¡£¿
¸ø²ÎÊý¸³Öµ¡¡ÔõôŪ°¡£¿

with Query do begin
  tempParam=parameters.addparameter;
  tempParam.name='@begindate';
  tempParam.Da ......

MSSQL$SQLEXPRESS ·þÎñÆô¶¯ÎÊÌâ

 


MSSQL$SQLEXPRESS  ÎÞ·¨Æô¶¯..  ÖªµÀÈçºÎ´¦ÀíµÄÇë°ï°ïæ  лл
¿´¿´´íÎóÈÕÖ¾

Ìáʾʲô´íÎó?

http://blog.csdn.net/fredrickhu/archive/2009/09/20/4573408.aspx
......

¹ØÓÚMSSQLÊý¾Ý¿â½ÇÉ«ÊôÐÔȨÏÞÑ¡ÔñÎÊÌâ



ÇëÎÊÔÚ¸³ÓèÊý¾Ý¿â½Çɫʱ£¬»áÓÐÕâ¸öȨÏÞÑ¡ÔñÃæ°å£¬Í¨³£MSSQLÀïÃæµÄ¿ò¿ò¶¼ÊÇ¿Õ×Å£¬Õâ¸öȨÏÞÑ¡Ôñ¿òÓÐÈýÖÖ״̬£¬
1¡¢¿Õ×Å
2¡¢Ñ¡ÖУ¬ÂÌÉ«µÄ¹´
3¡¢È¡Ïû£¬ºìÉ«µÄ²æ²æ¡£

Ñ¡ÖкÜÈÝÒ×Àí½â£¬µ«Èç¹û¶¼²» ......

ΪʲôMSSQLÖеÄGUIDÀàÐÍÓÐÁ½¸ö{}µÄ¡£²»·½±ã°¡¡£

ΪʲôMSSQLÖеÄGUIDÀàÐÍÓÐÁ½¸ö{xxxxxx}µÄ¡£²»·½±ã°¡¡£

µØÖ·´«ÖµµÄʱºòÕâÑùºÃ²»ºÃµÄ£¿

ĬÈÏÊä³öP¸ñʽ
-----------
ĬÈÏÊä³öÊÇB¸ñʽ...

ÉÏÃæËµÁË È¡³öÀ´¸ñʽ»¯Ò»ÏÂ

ѧϰÁË.

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