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

ÇëÎÊÓÐûÓÐÌå»ýСһµãµÄSQL SERVER·þÎñÆ÷Èí¼þ

ÎÒ¸ø±ðÈËдÁËÒ»¸öÈí¼þ£¬ÓõÄÊÇSQL SERVER 2005£¬µ«ÊǸø¿Í»§°²×°SQL SERVER 2005ÄÚ´æÕ¼ÓÃÌ«¶àÁË£¬ÇëÎÊ´ó¼ÒÓÐûÓÐÌå»ýСһµãµÄSQL SERVER 2005Êý¾Ý¿âÒýÇæ£¿
SQL   SERVER   2005   expressµ¥»úµÄ»°ÓÃÕâ¸ö
ÒªÁ¬Íø¾Í»»SQL2000
ûÆäËû°ì·¨

sql2000СµÃ¶àßÖ£¬Ö»ÄÜÓÃ2005Âð

ÒýÓÃ
ÎÒ¸ø±ðÈËдÁËÒ»¸öÈí¼þ£¬ÓõÄÊÇSQL SERVER 2005£¬µ«ÊǸø¿Í»§°²×°SQL SERVER 2005ÄÚ´æÕ¼ÓÃÌ«¶àÁË£¬ÇëÎÊ´ó¼ÒÓÐûÓÐÌå»ýСһµãµÄSQL SERVER 2005Êý¾Ý¿âÒýÇæ£¿

ÒªÓÃÊý¾Ý¿â,ÕâЩ×ÊÔ´ÏûºÄÊÇÉÙ²»Á˵Ä.

SQL EXPRESS 2005°É,Ãâ·Ñ,¿ÉÁªÍøÊ¹ÓõÄ.Ö»ÊÇûÓйÜÀíÆ÷(¿ÉÁíÍâÏÂÔØ),Êý¾Ý¿â×î´ó2G

ÎÒ¸ø±ðÈËдÁËÒ»¸öÈí¼þ£¬ÓõÄÊÇSQL SERVER 2005£¬µ«ÊǸø¿Í»§°²×°SQL SERVER 2005ÄÚ´æÕ¼ÓÃÌ«¶àÁË£¬ÇëÎÊ´ó¼ÒÓÐûÓÐÌå»ýСһµãµÄSQL SERVER 2005Êý¾Ý¿âÒýÇæ£¿
SQL code:

Äã°Ñ²»ÐèÒªµÄmssql·þÎñ¶¼¹ØÁË£¬Ö»ÁôÒ»¸öÊý¾Ý¿â·þÎñ...



ÄǾ͸ÄÓÃMySQL or PostgreÖ®ÀàµÄСÇÉÐͰÉ
SQL 2005¼°ÒÔºó»ùÓÚ.Net£¬±¾ÉíÅÓ´ó£¬ÔÚÇáÐ͹¤×÷״̬ÏÂЧÂʲ¢²»ºÃ


Ïà¹ØÎÊ´ð£º

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

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

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......

SQL clr - MS-SQL Server / ·Ç¼¼Êõ°æ

ÏëÓÃSQL CLR×öÈçϵĴ洢¹ý³Ì,µ«ÊÇ·¢ÏÖ±¨´í: 
{ÓÉÓÚ´úÂëÒѾ­¹ýÓÅ»¯»òÕß±¾»ú¿ò¼ÜλÓÚµ÷ÓöÑÕ»Ö®ÉÏ£¬ÎÞ·¨¼ÆËã±í´ïʽµÄÖµ¡£} 
¶øÇÒÈç¹ûÊý¾Ý´Ócase 1ͨ¹ýʱ¾ÍÊÇÕýÈ·µÄ,´Ócase 2ͨ¹ýʱ´íÎó 
²¢ÇÒÔÚc ......

sqlserver´íÎó - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ