Á¬½ÓMSSQLµÄÎÊÌâ
ÎÒµÄjava³ÌÐòÒªÁ¬½ÓÔ¶³ÌµÄÊý¾Ý¿âMSSQL£¬µ«ÊÇÔ¶³Ì·þÎñÆ÷£¬Ã»Óпª1433¶Ë¿Ú£¬ÓÐʲô°ì·¨ÄÜÈÃÎÒµÄjava³ÌÐòÁ¬½ÓÔ¶³ÌÊý¾Ý¿â
ÊÇ˵mysqlÂð£¿
ÎÒÒ²Óöµ½ÁËÕâ¸öÎÊÌ⣬ÎÒÒ²ÏëÇó½â¾ö£¬ºÇºÇ£¬°ïÄã¶¥¶¥£¡
MSSQL,¾ÍÊÇ΢ÈíµÄservice sql 2000
Ŷ Ã»Íæ¹ý ´¿°ó¶¨
¶ò£¬Ã»¿ª¶Ë¿Ú¹À¼Æ²»ºÃ°ì°É£¬°ï¶¥ÁË
¸úÁ¬½ÓOracleÒ»ÑùÁ¬°¡
Ã²ËÆÁ¬½ÓoracleÒ²ÓÐÓõ½1521¶Ë¿Ú°É
¶Ë¿Úû¿ª£¬ÔõôÓ𡣿°ï¶¥
û¿ª¶Ë¿Ú ºÃÏñ ²»Ðаɣ¡£¡£¡£¡
ÒªÇóÔ¶³Ì»úÆ÷¿ª·Å¶Ë¿Ú°¡£¬Òª²»ÉñÏÉҲû°ì·¨
û¿ª¶Ë¿Ú²»Ðеġ£
Òª½ø·¿¼äµÃÓÐÃÅ¡£ÆÆÇ½¶øÈë¹À¼Æ»áÓз¨ÂÉÎÊÌâàÞ£¬ºÙºÙ£¬¿ª¸öÍæÐ¦
²»¿ªÕâ¸ö¶Ë¿ÚÊÇÎÞ·¨Á¬½Ó
²»¿ª¶Ë¿ÚÎÞ·¨Á¬½Ó.
Ò»¸ö³ÌÐòµÄ±êÖ¾ÊÇIPµØÖ·¼Ó¶Ë¿ÚºÅ, Èç¹ûÖ»ÓÐIPµØÖ·, ¶øÃ»Óж˿ںÅ, ˵Ã÷¾ÍÕÒ²»µ½Õâ¸ö³ÌÐò.
ÎÒÒª·ÃÎÊCSDN,¿ÉÊÇCSDNûÓпª·þÎñÆ÷£¬ÎÒÔõô·ÃÎʰ¡£¿
Õâ¸öÎÊÌâ¡£¡£
»ù±¾ÉÏ¡£¡£Äã¿ÉÒÔÕÒ¸öºÚ¿ÍÈ¥°ÑËûÃÇ·þÎñÆ÷ºÚÁË
È»ºó¡£¡£¡£Ï뿪ɶ¿ªÉ¶
Ïà¹ØÎÊ´ð£º
mssqlÈçºÎÖ»ÏÔʾÓÐÖØ¸´µÄÊý¾ÝÄØ£¿
ÓÐÖØ¸´µÄÊý¾Ý¾ÍÏÔʾһÌõÖØ¸´µÄÊý¾Ý£¬Ã»Öظ´µÄ²»ÏÔʾ£¬²éѯÓï¾ä¸ÃÔõÃ´Ð´ÄØ£¿Ð»Ð»
SQL code:
select distinct *
from tablename
where id in (
selec ......
ƽ°²Ò¹¸øÃ»ÊÕµ½ÀñÎïµÄGG &&MM ÎÒÀ´ËÍÀñÎïÀ²¡£
ÊÕµ½ÀñÎïµÄ¾Í±ð½Ó·ÖÁË£¡ÒªÊǽӲ»µ½°Ñ×Ô¼ºµÄ³ôÍà×ÓÄóöÀ´£¬µÈÊ¥µ®ÀÏÈËÍíÉÏËÍÄã°É£¡
SF
bd
sf
À´jfµÄ
²»´©Íà×Ó
JAVA php JS MYSQL C# °æ¶¼·¢Í ......
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
±íµÄ½á¹¹ÈçÏ£º
±í1£ºtb_big
×ֶΣºfalseIDÖµ£º1£¬2
×ֶΣºbigtype Öµ£ºA£¬B£¨ÓëfalseIDµÄÖµµÄλÖÃÒ»Ò»¶ÔÓ¦£¬¼´1¶ÔÓ¦A£¬2¶ÔÓ¦B£©
±í2£ºtb_small
×ֶΣºfalseID£¨Óëtb_bigµÄfalseID¹ØÁªµÄ ......
´æ´¢¹ý³ÌÊÇÕâôдµÄ£¬
Declare @id int
BEGIN TRANSACTION
Insert into xxxxxTable(f1,f2)values(@a,@b)
Select @id=@@identit ......