ÇóSqlÓï¾äÒ»Ìõ - MS-SQL Server / »ù´¡Àà
Ò»¸ö±í a £¬×öÁËÒ»¸öa ±íµÄ ±¸·Ý È¡Ãû a_bak£¨×ֶζ¼ÊÇÏàͬµÄ£©¡£
ÏÖÔÚ ²»Ð¡ÐÄ°Ñ a ±íijһÌõ¼Ç¼¸øɾ³ýÁË£¬µ«ÊÇ Ò²²åÈë a_bak±íÖУ¬
ÏÖÔÚ ÈçºÎ°Ñ a_bak ±íÖÐÄÇÒ»Ìõ¼Ç¼ ÔÙ²åÈë a±íÖÐ....???
ÓÉÓÚa±íÖÐ µÄ×ֶηdz£µÄ¶à£¬
insert Ä¿±ê±íÃû£¨×Ö¶ÎÁÐ±í£© select ×Ö¶ÎÁбí from Ô´±íÃû where ¿½±´Ìõ¼þ
×Ö¶ÎÁÐ±í ¾ÍҪд °ÑËùÓÐ×ֶζ¼Ð´½øÈ¥£¬
Õâ¸ö ·½·¨ ¾ÍÏԵñȽϸ´ÔÓ£¬ºÜÂé·³...
»¹ÓÐû ¸üºÃµÄ·½·¨£¿£¿£¿
¾ÍÓÃinsert into °É
²»ÓÃдÌõ¼þ insert a select * from a_bak where Ìõ¼þ
SQL code:
insert into b (id)
select id from a_back
ûÓиüºÃµÄ°ì·¨£¬²»¾Í²ÅÒ»Ìõ¼Ç¼Âð£¬Âé·³Ò²¾ÍÊÇÒ»´Î¡£
×îºÃµÄ·½·¨ÊÇ°ÑÄãÕýʽ±íɾ³ý£¬°Ñ±¸·Ý±íÈ«²¿¿½±´Ò»ÏÂÔÙ¸´ÖÆÒ»·Ý¾ÍÐУ¬´úÂ붼²»ÓÃд¡£
insert into
ÓÃÕâ¾äÏÔʾ³öËùÓеÄ×Ö¶ÎÃû
SQL code:
select name from syscolumns where id = object_id('a')
ÔÙ±à¼Ò»Ï¾ͿÉÒÔÓÃÁË
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
SQL code:
rs.open "select * from guide where city_name='±±¾©' order by pai desc",conn,1,1
do while not rs.eof or rs.bof
¡£¡£
¡£¡£
¡£¡£
rs.movenext
loop
Õâ¸ösqlÓï¾äÔÚwapÕ¾Àï ±¾ÉíÓÐ ......