请教一个存储过程问题

[qq812689698]

以下是建立的存储过程
CREATE proc [dbo].[QQ_infoexe7]
@flag text
as
select @flag from qq_info

GO


执行
exec QQ_infoexe7 @flag=qq_id

但是这样结果不对呢？在SELECT如何加写参数？

[叶子]

create proc [dbo].[QQ_infoexe7]
@flag int
as
begin
    select * from qq_info where flag=@flag
end  

[叶子]

--理解错了，修正一下：

CREATE proc [dbo].[QQ_infoexe7]
@flag varchar(200)
as
exec('select'+ @flag +' from qq_info')


exec QQ_infoexe7 'qq_id'

[叶子]

--又少了个空格，不好意思

create proc [dbo].[QQ_infoexe7]
@flag varchar(200)
as
exec('select '+ @flag +' from qq_info')

--执行
exec QQ_infoexe7 'qq_id'

[mugua604]

CREATE proc [dbo].[QQ_infoexe7]
@flag text
as
DECLARE @SQL NVARCHAR(MAX)

SET @SQL ='SELECT '+ @flag+' FROM qq_info'


exec @SQL

GO