declare @a nvarchar(4000)
set @s=N'select @b='+@field+' from '+@table+'where username= '''+@key+ ''''
execute sp_executesql @s,N'@b varchar(500) out',@b out
set @s=N'select @b='+@field+' from '+@table+'where username= '''+@key+ ''''
execute sp_executesql @s,N'@b varchar(500) out',@b out
@field varchar(50),
@table varchar(50),
@key varchar(50),
@b varchar(500) OUTPUT
as
begin
declare @a nvarchar(4000)
set @a=N'select @b='+@field+' from '+@table+'where username='''+@key+''''
exec sp_executesql @a,N'@b varchar(500) output',@b output
return
end
GO