ÇóSQLÓï¾ä
ÔÊý¾Ý£º
id sdate
11235 2009-11-16
11236 2009-11-16
11237 2009-11-16
11238 2009-11-16
11240 2009-11-16
11241 2009-11-16
11242 2009-11-16
updateºóµÄÊý¾Ý£º
id sdate
11235 2009-10-16
11236 2009-10-16
11237 2009-10-16
11238 2009-10-16
11240 2009-10-16
11241 2009-10-16
11242 2009-10-16
¾ÍÊǰÑ11±ä³É10
SQL code:
update tb_name set sdate='2009-10-16' where sdate='2009-11-16'
??
update tt set sdate=DATE_ADD(sdate,INTERVAL -1 MONTH)
´ó¸ç£¬ÎÒ²»Ö»ÊÇÓÐ2009-11-16
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......
ΪÁËÂú×ãÊý¾Ý²éѯµÄËÙ¶ÈÎÊÌ⣬ÎÒ½«Ò»ÕÅÊý¾ÝÁ¿´óµÄѧÉú±í°´Äê¶È·Ö³É¶à¸ö±í
students_2008, students_2009È»ºóÎÒÓÖ×öÁËÒ»¸öÄ£°å±ístudents_template,Ä£°å±íÖеÄ×ֶκÍstudents_2008, students_2009Ò»Ñù£¬Ö»²»¹ýÊÇÒ»¸ö ......
ÓÐ2¸ö±í°¡£º
±íÃû£ºyh
Óû§±àÂë Óû§Ãû³Æ
001 a
002 b
003 c
±íÃû£ºys
Óû§±àÂë ±¾ÆÚÖ¸Êý ³±íʱ¼ä
001 ......