SQLÓï¾ä´óСд
±íÃû:ABC
select * from abc ÌáʾÕÒ²»µ½¶ÔÏó
select * from ABC ÕýÈ·.
Õâ¸ö´óСдÔÚÄÄÀïÉèÖõÄ?
ÒÔǰ½¨µÄ¿âµ¹Ã»Õâ¸öÎÊÌâ.ºóÔÚ±¾ÉíÖØÐ½¨Á¢Ò»Ð¿â.ÓÉÓÚ³ÌÐòÖлù±¾ÉÏȫΪСд.³ÌÐòÎÞ·¨ÔËÐÐ.È«ÊÇ´íÎóÌáʾ.ÕÒ²»µ½¸Ã¶ÔÏó.
ÐÞ¸ÄÅÅÐò¹æÔò
¶¥
ÅÅÐò¹æÔò³£見問題Õû體Ìû
http://blog.csdn.net/wufeng4552/archive/2009/09/22/4579654.aspx
ÎÒһֱʹÓÃĬÈϵÄÅÅÐò¹æÔò.֮ǰҲûÓгöÏÖ¹ýÎÊÌâ.ÎÒÏÈ¿´¿´
ÐÐÁ˸ijÉCI¾ÍÐÐÁË
Ïà¹ØÎÊ´ð£º
×îÏÈϵͳװÓÐsql2000£¬ÀïÃæÒ²ÔËÐÐÁ˺öàÍøÕ¾Êý¾Ý¿âÓ¦ÓóÌÐò£¬ÏÖÔÚÓиöÍøÕ¾ÐèÒªÅÜÔÚsql server2005ƽ̨ÉÏ£¬ÇëÎÊÎÒ¿ÉÒÔÖ±½ÓÔÚÕâ¸ö°²×°ÓÐsql server2000µÄ·þÎñÆ÷ÉÏÖ±½Ó°²×°sql server2005Â𣿻᲻»áÁ½¸ö°æ±¾µÄ·¢Éú¼æÈÝÐ ......
PBÖпª·¢µÄ¡£
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......
±íA
¿¨ºÅ ʱ¼ä
1 null
2 null
3   ......
ÎÒµÄÓï¾äΪstr1.Format("UPDATE wz set title='%s',class='%s',nr='%s' WHERE title=m_xb1",
m_bt, strTemp, fromClipboard);
ÆäÖÐCString m_xb1;±£´æµÄÖµ£¬µ«ÊÇÕâ¸öÓï ......
±íA ÄÚ ÓÐid ºÍ name
Ï£Íû¸ù¾ÝA±íµÄname½øÐвéѯ,µ«ÊÇname¿ÉÄÜ»áÖØ¸´,ËùÒÔÐèÒªÅжÏ.
ÓÐÒ»¸ösqlº¯Êý f ,ËüµÄ²ÎÊýÊÇA±íµÄid×Ö¶Î,·µ»ØÒ»¸öÖµ.
ÎÒÏ£Íû×îºóµÃµ½Ò»¸ö±í,°üº¬id name ºÍ[×îºóº¯Êýf·µ»Ø ......