Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQLÓï¾ä´óСд

±íÃû:ABC
select * from abc ÌáʾÕÒ²»µ½¶ÔÏó
select * from ABC ÕýÈ·.
Õâ¸ö´óСдÔÚÄÄÀïÉèÖõÄ?

ÒÔǰ½¨µÄ¿âµ¹Ã»Õâ¸öÎÊÌâ.ºóÔÚ±¾ÉíÖØÐ½¨Á¢Ò»Ð¿â.ÓÉÓÚ³ÌÐòÖлù±¾ÉÏȫΪСд.³ÌÐòÎÞ·¨ÔËÐÐ.È«ÊÇ´íÎóÌáʾ.ÕÒ²»µ½¸Ã¶ÔÏó.


ÐÞ¸ÄÅÅÐò¹æÔò

  ¶¥

ÅÅÐò¹æÔò³£見問題Õû體Ìû
http://blog.csdn.net/wufeng4552/archive/2009/09/22/4579654.aspx

ÎÒһֱʹÓÃĬÈϵÄÅÅÐò¹æÔò.֮ǰҲûÓгöÏÖ¹ýÎÊÌâ.ÎÒÏÈ¿´¿´

ÐÐÁ˸ijÉCI¾ÍÐÐÁË


Ïà¹ØÎÊ´ð£º

sql server2005¿ÉÒÔÓësql server 2000¹²´æÂð£¿

×îÏÈϵͳװÓÐsql2000£¬ÀïÃæÒ²ÔËÐÐÁ˺öàÍøÕ¾Êý¾Ý¿âÓ¦ÓóÌÐò£¬ÏÖÔÚÓиöÍøÕ¾ÐèÒªÅÜÔÚsql server2005ƽ̨ÉÏ£¬ÇëÎÊÎÒ¿ÉÒÔÖ±½ÓÔÚÕâ¸ö°²×°ÓÐsql server2000µÄ·þÎñÆ÷ÉÏÖ±½Ó°²×°sql server2005Â𣿻᲻»áÁ½¸ö°æ±¾µÄ·¢Éú¼æÈÝÐ ......

sql ÎÊÌâ

PBÖпª·¢µÄ¡£

DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......

ÇósqlÓï¾äÀí½â

±íA
¿¨ºÅ        ʱ¼ä
1                null
2                null
3      ......

¸üÐÂsqlÓï¾ä

ÎÒµÄÓï¾äΪstr1.Format("UPDATE wz set title='%s',class='%s',nr='%s' WHERE title=m_xb1",
m_bt, strTemp, fromClipboard);
ÆäÖÐCString m_xb1;±£´æµÄÖµ£¬µ«ÊÇÕâ¸öÓï ......

sqlÓï¾ä Çó½Ì

±íA ÄÚ ÓÐid ºÍ name

Ï£Íû¸ù¾ÝA±íµÄname½øÐвéѯ,µ«ÊÇname¿ÉÄÜ»áÖØ¸´,ËùÒÔÐèÒªÅжÏ.

ÓÐÒ»¸ösqlº¯Êý f ,ËüµÄ²ÎÊýÊÇA±íµÄid×Ö¶Î,·µ»ØÒ»¸öÖµ.

ÎÒÏ£Íû×îºóµÃµ½Ò»¸ö±í,°üº¬id name ºÍ[×îºóº¯Êýf·µ»Ø ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ