这里有错误吗？

[hssh38]

CREATE PROCEDURE [SearchBbs]
@Form int=0,
@Field varchar(30),
@Keyword nvarchar(255)='%'
AS
If @Form=0
select * from titles where Subject like @keyword order by LastNewsDate Desc
Else
select * from titles where BoardID=@Form and @Field like @keyword order by LastNewsDate Desc
GO

[Jpp]

没看出语法的错误。

如果你建立时有错，可能与你的表有关。如表不存在、字段名错误。。。

[warning]

select * from titles where BoardID=@Form and @Field like @keyword order by 有错，要用动态sql

[hssh38]

这个存储过程怎么不能执行呢，当参数传入时。这样行吗？
CREATE PROCEDURE [SearchBbs]
@Form int=0,
@Field varchar(30),
@Keyword nvarchar(255)='%'
AS
If @Form=0
select * from titles where @Field like @keyword order by LastNewsDate Desc
Else
select * from titles where BoardID=@Form and @Field like @keyword order by LastNewsDate Desc
GO

[hssh38]

急！

[愉快的登山者]

If @Form=0
exec("select * from titles where "+@Field+" like "+@keyword+" order by LastNewsDate Desc")
Else
exec("select * from titles where BoardID="+@Form+" and "+@Field+ "like "+@keyword+" order by LastNewsDate Desc")
GO