菜鸟请教语法问题

[kinki1980]

CREATE PROCEDURE up_select
@checked boolean,
@type varchar(50),
@edit varchar(50)
AS
if (@checked)
select * from customer where @type like' %'@edit% 'order by custid
else
select * from customer where @type=@edit order by custid

我是新手。。看了半天也不知道怎么回事。。请赐教！！

[kinki1980]

原来还有这个问题啊。。那要怎么解决啊。。详细点好吗？
这样行吗？
exec('select * from customer where @type='+@edit+' order by custid')

[kinki1980]

exec('select * from customer where @type=+'''+'@edit'+'''+ order by custid')
???????????

[kinki1980]

服务器: 消息 156，级别 15，状态 1，过程 up_select，行 7
在关键字 'select' 附近有语法错误。
服务器: 消息 156，级别 15，状态 1，过程 up_select，行 8
在关键字 'else' 附近有语法错误。

[wgsasd311]

CREATE PROCEDURE up_select
@checked bit,
@type varchar(50),
@edit varchar(50)
AS
if @checked=1
exec('select * from customer where '+ @type+' like ' +'''%'+@edit+'%'''+'order by custid ')
else
exec('select * from customer where '+@type+'='+@edit+' order by custid')

[kinki1980]

谢谢。。最好能讲解下。。不好意思。。我太菜了。。！！

[churchatp1]

用动态sql
因为你的@type，@edit 都是字符串，假设分别为‘a’，‘b’
select * from customer where @type=@edit order by custid
就相当于select * from customer where 'a'='b' order by custid
当然不对了

[kinki1980]

顶一顶！

[filebat]

楼主，你那个不行的@type是用来表示列名的。
exec('select * from customer where @type=+'''+'@edit'+'''+ order by custid')
中就不是列名啊。

wgsasd311(自强不息) 就可以，你试过了没？