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

SQL SERVER2000ÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

1¡£Êý¾Ý¿âÁ¬½ÓµÄʱºò£¬Èç¹ûÎÒÓÃÁ¬½Ó³Ø£¬°Ñ×î´óÁ¬½ÓÊýÉèÖÃΪ5£¬ÄÇôϵͳÔÚÎåÌìÒÔºóÊý¾Ý¿â¾Í»á±¨´í£¬Èç¹ûÎÒÉèÖÃΪ10£¬ÔòϵͳÔÚÊ®Ììºó¾Í³öÏÖ´íÎ󣬸оõºÜÆæ¹Ö¡£Ë­ÄÜ°ïÎÒ½âÊÍÏÂÂð£¿Ð»Ð»..
2¡£³ÌÐò¿ªÊ¼ÔËÐÐÕý³££¬¼¸Ììºó¾Í»áÁ¬½ÓÊý¾Ý¿âʧ°Ü£¬´Ó5ÔÂ20ÈÕ²¼ÉϵijÌÐòÔËÐÐÕý³£µ½5ÔÂ27ºÅÁ¬½ÓÁíÒ»¸ö·þÎñÆ÷ÉϵÄÊý¾Ý¿âʱ¾ÍÁ¬½Óʧ°ÜÁË£¬ÓÐË­Óöµ½¹ýÕâ¸öÎÊÌâÂð£¿
3¡£Á¬½Ó±¾µØÊý¾Ý¿âʱ£¬Ò²ÊÇ¿ªÊ¼¼¸ÌìÔËÐÐÕý³££¬½ñÌì·¢ÏÖÊý¾Ý¿â±¨³öһϴíÎó
SQL code:

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]½«
½Ø¶Ï×Ö·û´®»ò¶þ½øÖÆÊý¾Ý¡£
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source
)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(
Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Sour
ce)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType
(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown
Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)

at com.microsoft.jdbc.base.BaseStatement.c


Ïà¹ØÎÊ´ð£º

Çë½ÌSQLSERVERµÄÁ½¸öÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......

¹ØÓÚSqlµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡


¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡

Ö±½ÓÖ´ÐоÍÐÐÁË

exec ......

Çóһʱ¼ä±È½ÏµÄSQL Ö¸Áî - MS-SQL Server / »ù´¡Àà

±íÊý¾Ý
COL1 COL2 COL2 COL4 COL5
----------------------------------------------------------------------------------------------
2010-05-05 00:00 ......

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ - MS-SQL Server / »ù´¡Àà

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ

¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿

Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ

º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£

sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ