Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 job²»ÄÜÖ´ÐÐ

¸÷λ´óÏÀ  £¬ÎÒ½ñÌì×öÁ˸öjob£¬sqlÊÇ exec  proc_showresult.
¿É¾ÍÊDz»ÄÜÖ´ÐÐ £¬È»ºóÎÒ°ÉÕâ¸ösql»»³É select 1¡£¾ÍûÎÊÌ⣬ÕâÊÇʲôԭÒò°¡  Çë¸ßÊÖÖ¸½Ì
´æ´¢¹ý³ÌÓвÎÊýû??
Ò²ÐíÊÇÖ´ÐÐÁË,Äãû ......

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

asp+mssqlÈçºÎÈÃÒ»¸ö±í°´ÁíÒ»¸ö±íµÄÌõ¼þ½øÐвéÑ¯ÄØ£¿

asp+mssqlÈçºÎÈÃÒ»¸ö±í°´ÁíÒ»¸ö±íµÄÌõ¼þ½øÐвéÑ¯ÄØ£¿

±ÈÈç ±í1 ÓÐ
1
2
3
3ÌõÊý¾Ý

±í2ÓÐ
1  10
2  30
3  5

ÎÒÏëÈñí1°´±í2À´½µÐòÅÅÁУ¬¸ÃÈçºÎÐ´ÄØ£¿
2 ......

¹ØÓÚoracleÊý¾Ý¿âÒÆÖ²µ½mssqlµÄÎÊÌâ.

ÆäÖÐÒ»¸öoracleÊý¾Ý¿âÖÐÆäÖÐÒ»¸ö±íÓжà¸öʱ¼ä´Á×Ö¶Î,mssqlÖ»ÄÜÔÊÐíÒ»¸öµÄ.
ʵÔÚÓÐÎÊÌâµÄ»°£¬ ¿ÉÒÔÏȽ¨Á¢ÁíÍâµÄÒ»ÕÅ±í£¬È»ºó°Ñtimestamp¸ÄΪdate£¬°ÑÊý¾Ý¸´ÖÆÒÔºó£¬ÔÚÒÆÖ²Ò»´Î


oracleµÄʱ¼ä´ÁºÏ²¢ÎªÒ»¸ö×ֶα ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ