MySQL ÖÐÎÄ´¦ÀíÎÊÌ⣿ - MS-SQL Server / Ó¦ÓÃʵÀý
select TableName_Eng from tablenameengtochi where TableName_Chi = ¹Ý²ØÍ¼ÊéÐÅÏ¢±í £»²éѯûÓз´Ó¦ ҲûÓб¨´í
£¿Çë¸ßÊÖÖ¸µã£¡
ÉÙµ¥ÒýºÅ
SQL code:
select TableName_Eng from tablenameengtochi where TableName_Chi = '¹Ý²ØÍ¼ÊéÐÅÏ¢±í'
MySQL£¿
²»¹ýÒ²Ò»Ñù£¬±ê×¼SQL
MSSQL:
SQL code:
select TableName_Eng from tablenameengtochi where TableName_Chi = N'¹Ý²ØÍ¼ÊéÐÅÏ¢±í'
SQL code:
select TableName_Eng from tablenameengtochi where TableName_Chi = '¹Ý²ØÍ¼ÊéÐÅÏ¢±í'
....
Ïà¹ØÎÊ´ð£º
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
ÎÒÓõÄÊÇmysql6.0Ϊʲôһ´´½¨Á½¸ö±íÕâ¼äÓÃÍâ¼üÀ´Á¬½Óʱ¾Í˵´´½¨²»ÁË£ºcan"nt create table ...
ÄãµÄÓï¾äÊÇʲô£¿ÄãµÄ±íÊÇʲô´æ´¢ÒýÇæ£¿ Èç¹ûÊÇmyisam Ôò²»Ö§³ÖÍâ¼ü£¬ÄãÐèÒª°Ñ±í¸ÄΪinndb
貼³öSQL ......