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

SQL¸ñʽת»»

ÎÒSQL2000ÀïÃæÓиö×Ö¶Î'×¢²áʱ¼ä'£¬ÎÒÏë×ö¸ö²éѯ£¬½á¹û³öÀ´ÊÇyyyy-mmÕâÖÖÀàÐ굀 ¾ÍÊÇÓÐÄê ÓÐÔÂûÓкóÃæµÄÈÕÆÚµÄ ÓÃconvert ÎÒÕÒÁ˺ܶàҲûÕÒµ½£¿
´ó¼ÒÒªÓÐÕâÑùµÄת»»µÄ˵Ã÷Ò²¸øÎÒ¹²ÏíÏ °ÝÍУ¡
½ö¹©²Î¿¼£º
C# code:

select cast(datepart(yyyy,×¢²áʱ¼ä) as varchar(4))+'-'+cast(datepart(mm,×¢²áʱ¼ä) as varchar(2)) as ÄêÔ from ±í




SQL code:

Convert ÓÃÀý£º
select
convert(varchar(4),datepart(yyyy,getdate()))+'-'
+convert(varchar(2),datepart(mm,getdate()))

---------------
2010-1




datepart

SQL code:
convert(varchar(10),getdate(),120)

²ÎÊý1:ÖµÀàÐÍ ---- varchar(10)
²ÎÊý2:ÖµÄÚÈÝ ---- getdate()
²ÎÊý3:Öµ¸ñʽ ---- 120

¸ñʽ120 ¶ÔÓ¦µÄÑùʽÊÇ yyyy-MM-dd
»¹ÓÐÆäËûºÜ¶à¸ñʽ£¬ÄãÔÙ²é²é°É

ÒýÓÃ
SQL codeconvert(varchar(10),getdate(),120)
²ÎÊý1:ÖµÀàÐÍ ---- varchar(10)
²ÎÊý2:ÖµÄÚÈÝ ---- getdate()
²ÎÊý3:Öµ¸ñʽ ---- 120

¸ñʽ120 ¶ÔÓ¦µÄÑùʽÊÇ yyyy-MM-dd
»¹ÓÐÆäËûºÜ¶à¸ñʽ£¬ÄãÔÙ²é²é°É


Ó¦¸ÃÊÇvarchar(7)  £º£©
convert(varchar(7)


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ