¸üÐÂsqlÓï¾ä
ÎÒµÄÓï¾äΪstr1.Format("UPDATE wz set title='%s',class='%s',nr='%s',[date]='%s' WHERE num='%d'",
m_bt, strTemp, fromClipboard, time5,m_num);
ÆäÖÐnum×Ö¶ÎΪÊý×ÖÊý¾ÝÀàÐÍ£¬m_numΪintÐÍ¡£
ÎÒÊÔÁËһϣ¬str1=UPDATE wz set title='1',class='ÄÚ²¿ÐÂÎÅ',nr='11',[date]='2009.¡£¡£' WHERE num='218'
Ó¦¸ÃûʲôÎÊÌâ°¡
¿ÉÊDZàÒëûÓдíÎó£¬ÔËÐоͳö´í
лл
Ïà¹ØÎÊ´ð£º
±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
3.ѧÉú±í£¬Ñ¡¿Î±í¡£¿Î³Ì±í¡£Èý¸ö±í£¬ÕÒ³öÑ¡ËùÓпγ̵ÄѧÉú¡£
4.ѧÉú±í£¬Ñ¡¿Î±í¡£¿Î³Ì±í¡£Èý¸ö±í£¬ÕÒ³öÑ¡ÁË5ÃÅÒÔÉϿγ̵ÄѧÉú¡£
5.ѧÉú±í£¬³É¼¨±í¡£¿Î³Ì±í¡£Èý¸ö±í£¬ÕÒ³öËùÓпγ̵ķÖÊýÔÚ80·ÖÒÔÉϵÄѧÉú¡£
......
Microsoft SQL Server 2005 JDBC Driver Õâ¸öÇý¶¯´ó¼ÒÓÐÓùýÂð£¿ÓÃʲô°æ±¾ºÅ¡£Î¢Èí¹ÙÍøÓÐ1.1µÄ»¹ÓÐ2.0µÄ£¬ÎÒÓõÄIDEÊÇJBuilder9
ÏÖÔÚÓÃ2.0µÄ°É£¬È¥Î¢ÈíÍøÕ¾ÏÂÔØ¼´¿É¡£Á¬½Ó×Ö·û´®ºÍÒÔǰÉÔÓв»Í¬£¬¿ÉÒÔËÑÒ»ÏÂÀ ......
1.´´½¨Ò»¸öÊý¾Ý¿âʱ
ÓдíÂð£¿Ëü×ÜÊÇÌáʾdbd.ldfÒѾ´æÔÚ µ«ÊÇÔõô¸ÄÃû¶¼»¹ÊÇÒ»ÑùÌáʾ´æÔÚ
create database testdb
on primary
(name=db1,filename='e:\java\zy\dba.mdf',size=1,maxsize=5,file ......