¸üÐÂsqlÓï¾ä
ÎÒµÄÓï¾äΪstr1.Format("UPDATE wz set title='%s',class='%s',nr='%s' WHERE title=m_xb1",
m_bt, strTemp, fromClipboard);
ÆäÖÐCString m_xb1;±£´æµÄÖµ£¬µ«ÊÇÕâ¸öÓï¾äÀïtitle¾ÍÖ±½ÓµÈÓÚm_xb1¡£Õâ¸ÃÔõô°ì£¿
str1.Format("UPDATE wz set title='%s',class='%s',nr='%s' WHERE title=%s",
m_bt, strTemp, fromClipboard,(LPCTSTR)m_xb1);
C/C++ code:
str1.Format("UPDATE wz set title='%s',class='%s',nr='%s' WHERE title='%s'",
m_bt, strTemp, fromClipboard, m_title);
//¶¼ÓÃÁËCString::FormatÁË£¬»¹..
str1.Format("UPDATE wz set title='%s',class='%s',nr='%s' WHERE title=%s",
m_bt, strTemp, fromClipboard,m_xb1);
Ïà¹ØÎÊ´ð£º
sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and ......
Microsoft SQL Server 2005 JDBC Driver Õâ¸öÇý¶¯´ó¼ÒÓÐÓùýÂð£¿ÓÃʲô°æ±¾ºÅ¡£Î¢Èí¹ÙÍøÓÐ1.1µÄ»¹ÓÐ2.0µÄ£¬ÎÒÓõÄIDEÊÇJBuilder9
ÏÖÔÚÓÃ2.0µÄ°É£¬È¥Î¢ÈíÍøÕ¾ÏÂÔØ¼´¿É¡£Á¬½Ó×Ö·û´®ºÍÒÔǰÉÔÓв»Í¬£¬¿ÉÒÔËÑÒ»ÏÂÀ ......
±í½á¹¹ÈçÏÂ
ID parentid Name
1 0 ´ó¿Í³µ
2 1 ½ðÁú
ÇëÎÊÈçºÎÓÃÒ»¶ÎsqlÎIJéѯ³öÈçϽá¹û
ID  ......
±íA
¿¨ºÅ ʱ¼ä
1 null
2 null
3   ......
´ó¼Ò¶¼ÓÃʲôsqlÓï¾ä±à¼¹¤¾ß£¡»¹ÊÇÖ»½ÓÓòéѯ·ÖÎöÆ÷£¿ÍøÉÏÕÒÁËЩPL/SQL developerÕâºÃÏñÊÇÁ¬OraclerµÄ
ÎÒÖ»ÏëÒª¸öSQl±à¼¹¤¾ß
SSMS.
²éѯ·ÖÎöÆ÷×ã¹»ÁË
±¾ÈË×î½üÔÚѧϰsql
µ«Ã¿´Î¶¼ÒªÍù²éѯ·ÖÎöÆ÷ÉÏÌ ......