ƽ°²Ò¹¸øÃ»ÊÕµ½ÀñÎïµÄGG &&MM ËÍ·Ö -MSSQL°æ
ƽ°²Ò¹¸øÃ»ÊÕµ½ÀñÎïµÄGG &&MM ÎÒÀ´ËÍÀñÎïÀ²¡£
ÊÕµ½ÀñÎïµÄ¾Í±ð½Ó·ÖÁË£¡ÒªÊǽӲ»µ½°Ñ×Ô¼ºµÄ³ôÍà×ÓÄóöÀ´£¬µÈÊ¥µ®ÀÏÈËÍíÉÏËÍÄã°É£¡
SF
bd
sf
À´jfµÄ
²»´©Íà×Ó
JAVA php JS MYSQL C# °æ¶¼·¢ÍêÁË
jf°¡
dingding
jf
ллС˧¸ç
¡£¡£¡£
ûÊÕµ½ÀñÎïµÄÀ´JF
...
sf
jf
o
jf
¶¥ÁË£¬ÓÐÀñÎï¸üºÃ
jf
jf
лл
ÎÒûÊÕµ½ÀñÎï ÎØÎØ
jf
jf
jf
jf
.
½Ó·Ö~
o
´©Íà×Ó
......
ûÓÐÊÕµ½ÀñÎ½Ó·Ö£¡
jf
jf
jf
.
·É¹ý
sf
jf
¹ÒÍà×Ó°¡
- -
JF
½ñÒ¹ÎÞÃß.Ïëϱ¸¾ÁË.ºÇºÇ
ºÇºÇ£¡JF
¸ç²»´©Íà×Ó
jfjf
½Ó·Ö£¬ºÇºÇ
ºÃÈË
JF
½Ó·Ö
jf
¶Ô²»Æð£¬Â¥Ö÷ÄãÊǺÃÈË¡£
day day up
Ê¥µ®¿ìÀÖ£¬È»ºóJF
×£¸£
Ïà¹ØÎÊ´ð£º
mssqlÈçºÎÖ»ÏÔʾÓÐÖØ¸´µÄÊý¾ÝÄØ£¿
ÓÐÖØ¸´µÄÊý¾Ý¾ÍÏÔʾһÌõÖØ¸´µÄÊý¾Ý£¬Ã»Öظ´µÄ²»ÏÔʾ£¬²éѯÓï¾ä¸ÃÔõÃ´Ð´ÄØ£¿Ð»Ð»
SQL code:
select distinct *
from tablename
where id in (
selec ......
ÊÇ·ñÄÜÔÚijЩINSERT,UPDATE,DELETEµÄʱºò,²»Ð´ÊÂÎñÈÕÖ¾?ÒòΪÎÒijЩ²Ù×÷²»ÐèҪдÈÕÖ¾(±ÈÈçÁÙʱ¼ÆËãÓõıí,ijЩÁÙʱͼ¿â)
ÎÒÏÖÔÚÖªµÀ:
ÔÚ¼òµ¥ÈÕ־ģʽÏÂ,SELECT INTO ²»²úÉúÈÕÖ¾,
Ìý˵ORACLE¿ÉÒÔʵÏÖijЩ ......
¸ßнƸMsSQL DBA - ÉϺ£ - 5+¾Ñé - Ó¢Óï¿É¹µÍ¨
н×Ê20wÒÔÉÏ£¬ÍêÈ«open
..
ºÙºÙ£¬ÓÐÐËȤ¡£
ӦƸ¹ý..µ«ÊÇÓ¢Óï²»¹ý¹Ø...ÓôÃÆËÀÎÒÁË...
̫Զ
ÍêÈ«open ɶÒâ˼ ˸ø½âÊÍÏÂ
·¹ý£¬¿Éϧ£¬È¥²»ÁË
һР......
ÎÒÏëʹÓÃ×Ô¶¯±àºÅ£¬µ«ÊDz»ÖªµÀÈçºÎʹÓÃÖ¸¶¨µÄÀàÐÍ×÷Ϊ×Ô¶¯±àºÅѽ¡£
±ÈÈç˵ÎÒÏëÎÒµÄ×Ô¶¯±àºÅÊÇ£º
A001
A002
A003
ÕâÑùÓ¦¸ÃÈçºÎ²Ù×÷ѽ£¬¸ßÊÖÖ¸µã¡£
ÐèÒª×Ô¼ºÐ´´úÂëÍê³É×Ô¶¯±àºÅ
´¥·¢Æ÷ º¯Êý ´æ´¢¹ý ......