存储过程语法问题??????
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[CheckExistValu]
(
@currNodeValue varchar(200),
@adminGroupNumber VARCHAR(200)
)
AS
declare @child nvarchar(4000);
select @child =ClassList from YN_sys_admingroup where adminGroupNumber=@adminGroupNumber
set @child=LTrim(RTrim(@child))
declare @selectSql nvarchar(4000);
select @selectSql='select * from yn_news_class where cast(classid as numeric) in('+substring(@child,1,len(@child)-1) +')'
declare @selectSql1 nvarchar(4000);
--set @selectSql1='select * from @selectSql where classid=@currNodeValue'
set @selectSql1='select * from @selectSql where classid='+@currNodeValue
exec (@selectSql1)