CREATE PROCEDURE SiaMemberQuery
@SelectFields varchar(50),
@Operation varchar(10),
@Value varchar(50)
AS
declare@sql varchar(500),
@sql1 varchar(200),
@sql2 varchar(50),
@sql3 varchar(150)
set @sql1='Select SiaMember_Cent, SiaMember_OrgNo, SiaMember_Corp from SiaMember where '
if @SelectFields = '会员编号'
set @sql2='SiaMember_No '
else if @SelectFields='企业名称(中文)'
set @sql2='SiaMember_Cent '
else
set @sql2='SiaMember_UserName '
if @Operation='类似于'
set@sql3=' Like '+'''%'''+'+'+''''+ @Value +''''+'+'+'''%'''
else if @Operation='等于'
set@sql3=' ='+''''+@Value+''''
else
set@sql3=' >'+''''+@Value+''''
set @sql=@sql1+''+@sql2+''+@sql3
select SQL=@sql
我的问题是：
执行存储过程，SQL是一个select 语句，要怎样做，才能执行这个SQL语句，返回需要的结果记录（而不是这个Select语句）？
|
