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

Á¬½ÓMSSQLµÄÎÊÌâ

ÎÒµÄjava³ÌÐòÒªÁ¬½ÓÔ¶³ÌµÄÊý¾Ý¿âMSSQL£¬µ«ÊÇÔ¶³Ì·þÎñÆ÷£¬Ã»Óпª1433¶Ë¿Ú£¬ÓÐʲô°ì·¨ÄÜÈÃÎÒµÄjava³ÌÐòÁ¬½ÓÔ¶³ÌÊý¾Ý¿â
ÊÇ˵mysqlÂð£¿


ÎÒÒ²Óöµ½ÁËÕâ¸öÎÊÌ⣬ÎÒÒ²ÏëÇó½â¾ö£¬ºÇºÇ£¬°ïÄã¶¥¶¥£¡

MSSQL,¾ÍÊÇ΢ÈíµÄservice sql 2000

Ŷ Ã»Íæ¹ý  ´¿°ó¶¨

¶ò£¬Ã»¿ª¶Ë¿Ú¹À¼Æ²»ºÃ°ì°É£¬°ï¶¥ÁË

¸úÁ¬½ÓOracleÒ»ÑùÁ¬°¡

Ã²ËÆÁ¬½ÓoracleÒ²ÓÐÓõ½1521¶Ë¿Ú°É

¶Ë¿Úû¿ª£¬ÔõôÓ𡣿°ï¶¥


û¿ª¶Ë¿Ú  ºÃÏñ  ²»Ðаɣ¡£¡£¡£¡

ÒªÇóÔ¶³Ì»úÆ÷¿ª·Å¶Ë¿Ú°¡£¬Òª²»ÉñÏÉҲû°ì·¨

û¿ª¶Ë¿Ú²»Ðеġ£
Òª½ø·¿¼äµÃÓÐÃÅ¡£ÆÆÇ½¶øÈë¹À¼Æ»áÓз¨ÂÉÎÊÌâàÞ£¬ºÙºÙ£¬¿ª¸öÍæÐ¦


ÒýÓÃ
ÒòΪ sqlÓõľÍÊÇ 1433¶Ë¿Ú

Äã²»¿ªÕâ¸ö¶Ë¿ÚÊÇÎÞ·¨Á¬½ÓµÄ¡£

µ«ÊÇÁ¬½ÓÔ¶³ÌµÄÊý¾Ý¿âʹÓà IPµØÖ·Á¬½Ó¾Í¿ÉÒÔÁË

¶Ë¿Ú 1433±ØÐ뿪·Å¡£

²»¿ªÕâ¸ö¶Ë¿ÚÊÇÎÞ·¨Á¬½Ó

²»¿ª¶Ë¿ÚÎÞ·¨Á¬½Ó.

Ò»¸ö³ÌÐòµÄ±êÖ¾ÊÇIPµØÖ·¼Ó¶Ë¿ÚºÅ, Èç¹ûÖ»ÓÐIPµØÖ·, ¶øÃ»Óж˿ںÅ, ˵Ã÷¾ÍÕÒ²»µ½Õâ¸ö³ÌÐò.

ÎÒÒª·ÃÎÊCSDN,¿ÉÊÇCSDNûÓпª·þÎñÆ÷£¬ÎÒÔõô·ÃÎʰ¡£¿



Õâ¸öÎÊÌâ¡£¡£
»ù±¾ÉÏ¡£¡£Äã¿ÉÒÔÕÒ¸öºÚ¿ÍÈ¥°ÑËûÃÇ·þÎñÆ÷ºÚÁË
È»ºó¡£¡£¡£Ï뿪ɶ¿ªÉ¶


Ïà¹ØÎÊ´ð£º

mssqlÈçºÎÖ»ÏÔʾÓÐÖØ¸´µÄÊý¾ÝÄØ£¿

mssqlÈçºÎÖ»ÏÔʾÓÐÖØ¸´µÄÊý¾ÝÄØ£¿
ÓÐÖØ¸´µÄÊý¾Ý¾ÍÏÔʾһÌõÖØ¸´µÄÊý¾Ý£¬Ã»Öظ´µÄ²»ÏÔʾ£¬²éѯÓï¾ä¸ÃÔõÃ´Ð´ÄØ£¿Ð»Ð»

SQL code:
select distinct *
from tablename
where id in (
selec ......

ƽ°²Ò¹¸øÃ»ÊÕµ½ÀñÎïµÄGG &&MM ËÍ·Ö -MSSQL°æ

ƽ°²Ò¹¸øÃ»ÊÕµ½ÀñÎïµÄGG &&MM ÎÒÀ´ËÍÀñÎïÀ²¡£
ÊÕµ½ÀñÎïµÄ¾Í±ð½Ó·ÖÁË£¡ÒªÊǽӲ»µ½°Ñ×Ô¼ºµÄ³ôÍà×ÓÄóöÀ´£¬µÈÊ¥µ®ÀÏÈËÍíÉÏËÍÄã°É£¡
SF

bd

sf

À´jfµÄ

²»´©Íà×Ó

JAVA php JS MYSQL C# °æ¶¼·¢Í ......

¹ØÓÚACCESSºÍMSSQLµÄÎÊÌâ - Web ¿ª·¢ / ASP

ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......

Âé·³´óϺÃǰïæдһ¸öMSSQLµÄ´¥·¢Æ÷£¬¼±ÓÃ

±íµÄ½á¹¹ÈçÏ£º

±í1£ºtb_big
×ֶΣºfalseIDÖµ£º1£¬2
×ֶΣºbigtype Öµ£ºA£¬B£¨ÓëfalseIDµÄÖµµÄλÖÃÒ»Ò»¶ÔÓ¦£¬¼´1¶ÔÓ¦A£¬2¶ÔÓ¦B£©

±í2£ºtb_small
×ֶΣºfalseID£¨Óëtb_bigµÄfalseID¹ØÁªµÄ ......

delphiÈçºÎ»ñÈ¡mssql´æ´¢¹ý³ÌµÄ·µ»ØÖµ

´æ´¢¹ý³ÌÊÇÕâôдµÄ£¬
Declare @id int
    BEGIN TRANSACTION
 
      Insert into xxxxxTable(f1,f2)values(@a,@b)
      Select @id=@@identit ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ