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 = '¹Ý²ØÍ¼ÊéÐÅÏ¢±í'
....
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
ÏëÒªµÄ½á¹ûÊÇ:
1,Na ......
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
ÎÒ¾õµÃmysqlºÍsqlserverÓй²Í¬µÄµØ·½£º
ÓиöÎÊÌâÊǹØÓÚ±íµÄËøÎÊÌ⣺
½ø³ÌA ½ø³ÌB
select * from user where id in lock share mode£¨¹²ÏíËø)
&nb ......