ÇóÒ»SQLÓï¾ä
ÔÊý¾Ý
ÉÌÆ· Ô¼Û ´òÕÛ·½Ê½1 ÕÛ¿Û1 ´òÕÛ·½Ê½2 ÕÛ¿Û2
±Ê¼Ç±¾ 10000 NULL 0 NULL 0
µçÊÓ»ú 2000 ´ÙÏú 200 NULL 0
±ùÏä 3000 ´ÙÏú 300 ÀÏ¿Í»§ 400
ÒªµÃ³ö½á¹û
ÉÌÆ· ´òÕÛ·½Ê½ ¼ÛÇ®
±Ê¼Ç±¾ NULL 10000
µçÊÓ»ú ´ÙÏú 2000
µçÊÓ¾ç ´ÙÏú -200
±ùÏä ´ÙÏú 3000
±ùÏä ´ÙÏú -300
±ùÏä ÀÏ¿Í»§ -400
ÐèÇóµÄ±È½ÏÆæ¹Ö¡£
´ó¸ÅÀ´Ëµ£¬Ã¿¸öÓÐЧµÄÕÛ¿Û£¬¶¼ÁíÍâÆðÒ»ÐУ¬²¢Ê¹ÓøºÊý±íʾ
ʵÏÖÆðÀ´±È½ÏÆæ¹Ö£¬¼Ó·Ö
union all
SQL code:
select ÉÌÆ· as ÉÌÆ· ,´òÕÛ·½Ê½1 as ´òÕÛ·½Ê½,Ô¼Û as ¼ÛÇ® from ±í
union all
select ÉÌÆ·,-´òÕÛ·½Ê½1,ÕÛ¿Û1 from ±í
union all
select ÉÌÆ·,-´òÕÛ·½Ê½2,ÕÛ¿Û2 from ±í
union all
Ïà¹ØÎÊ´ð£º
PBÖпª·¢µÄ¡£
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÇëÎÊ£º
1,ÈçºÎ½«Ò»ÕÅdbf±íµ¼Èëµ½sql server2000ÖеÄÒ»ÕÅ±í¡£Ê¹ÓÃDTS¸ÃÔõÑùʵÏÖ£¿
2,ʹÓÃÍøÉÏ´úÂ룺
Insert Into Tb_cj Select * from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro D ......
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
СµÜÕý×¼±¸×Ô¼ºÌáǰѧϰÊý¾Ý¿â£¬µ«ÊÇÏÖÔÚÓиöÎÊÌ⣬²»ÖªµÀ¸ÃÑ¡Ôñʲô°æ±¾µÄSQL
ѧУÒÔºóµÄÊéºÃÏñ½²SQLÓõÄÊÇSQL 2000£¬µ«ÊÇÎÒµÄϵͳÊÇWindows 7£¬Ã²ËƲ»ÄÜ×°£¬Ò²²»Ïë»»»ØXP£¨07Äê¾Í²»ÓÃXPÀ²£©£¬ËùÒÔÔÚÏ룬ÄÜ· ......