sql语句错误
---模糊查找---
if exists(select * from sysobjects where name='proc_fuzzySearch')
drop proc proc_fuzzySearch
go
create proc proc_fuzzySearch
@keyword nvarchar(20)
as
select * from (select Products.PID,Products.CID,Products.PName,company.CID,company.CName from products,company where Products.CID=company.CID) where Products.PName like '%'+@keyword+'%' or company.cname like '%'+@keyword+'%'
go
products商品表 company公司表 product中CID是引用company表中的外键。想现实如我输入“钢铁”就能查出商品中有“钢铁”这个词和公司名称中有“钢铁”这个词的所有商品。用了两表联查。
错误信息
消息 156，级别 15，状态 1，过程 proc_fuzzySearch，第 4 行
关键字 'where' 附近有语法错误。
SQL code:
if exists(select * from sysobjects where name='proc_fuzzySearch')
drop proc proc_fuzzySearch
go
create proc proc_fuzzySearch
@keyword nvarchar(20)
as
select * from (select Products.PID,Products.CID,Products.PName,company.CID,company.CName from products,company where Products.CID=company.CID) t
where Products.PName like '%'+@keyword+'%' or company.cname like '%'+@keyword+'%'
go
SQL code:
if exists(select * from sysob
相关问答：
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'亿'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
为什么上一个用varchar转换后就只保留了� ......
CREATE PROCEDURE [selectvipcompany]
@username varchar(50),
@companyname varchar(50),
@endtime varchar(1)
AS
declare @sql varchar(1000)
set @sql='' ......
数据库要怎么学才不会显得抽象啊？
这就要看你适合什么方法了，这具体不好说的.....
怎么了，难道大家都不会，还是真的太抽象大家不知道怎么说啊
结合你操作数据库的体会和理解，应该效果会更好。否则，� ......
<table style="width: 1000px"><tr>
<td style="height: 38px; width: 35px;">
姓名</td>
......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
