问个简单的查询问题 select * from person where (job like '%key%' or iname like )and yuex='%yuex%' order by id desc 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from person where (job like '%key%' or iname like '%key%')and yuex='%yuex%' order by id desc ------上面寫錯了,改正select * from person where (job like '%key%' or iname like '%key%')and yuex='yuex' order by id desc select * from person where (job like '%key%' or iname like '%key%')and yuex='yuex' order by id desc select * from person where (job like '"&key&"' or iname like '"&key&"' )and yuex='"&yuex&"' order by id select * from person where (job like '%key%' or iname like '%key%')and yuex='yuex' order by id desc 为什么select * from company where job & cname like '%"&key&"%' order by id desc不行?在access中可以,sql中就不行了。 在sql 中連接號不是 & 是+select * from company where job + cname like '%key%' order by id desc VS2010自带的SQL2008 Win7下怎么安装SSMS啊?我去微软网站上下的怎么安装不上 用代码如何判断 SQL查询语句结果的记录数? 存储过程带入参数 关于两表查询的问题 一超难的sql查询 求一SQL,关于include 请问,SQL SERVER 2000的数据库可以完整的搬迁到SQL SERVER 2005吗? 存储过程怪问题!存储过程返回值无法显示 为什么我不能给变量赋值? Stored Procedures去处理多个表格Select 关于这条SQL的进一步功能完善。 数据库管理员的职业前景如何?这类人才需求如何?
select * from person where (job like '%key%' or iname like '%key%')and yuex='yuex' order by id desc
and yuex='"&yuex&"' order by id
where (job like '%key%' or iname like '%key%')
and yuex='yuex'
order by id desc
select * from company where job & cname like '%"&key&"%' order by id desc不行?
在access中可以,sql中就不行了。
select * from company where job + cname like '%key%' order by id desc