怎么样在存储过程中定义以下格式？

[wuhuanjob]

@FristNum char(8),
@LastNum char(8),
@AllNum char(8)
AS
SELECT * FROM code WHERE (soccode like ‘@FristNum%%@LastNum’) AND (soccode
<> ‘@AllNum’) ORDER BY title

这样写是错的，或者说是怎么解决'在存储过程里的显示？

[pbsql]

SELECT * FROM code WHERE (soccode like @FristNum+'%'+@LastNum) AND (soccode
<>@AllNum) ORDER BY title

[wuhuanjob]

回复人： pbsql(风云) ( ) 信誉：127
-----------------------------------------------
你的方法是错的

[xluzhong]

动态sql
@FristNum char(8),
@LastNum char(8),
@AllNum char(8)
AS
DECLARE @SQL NVARCHAR(4000)
SET @SQL='SELECT * FROM code WHERE (soccode like '+''''+@FristNum+'%'+@LastNum+''''+') AND (soccode<> '+@AllNum+ ') ORDER BY title'

EXEC (@SQL)

[子陌红尘]

SELECT
*
FROM
code
WHERE
soccode like @FristNum + '%'
and
soccode like '%' + @LastNum
AND
soccode <> @AllNum
ORDER BY
title