函数里动态实现sql
我想在函数里动态执行sql,不知道可以不?
ALTER function [dbo].[test]
(
@tableName varchar(50) ,
@columnName varchar(50),
@id int
)
returns nvarchar(50)
as
begin
declare @str nvarchar(50)
declare @v int
select @v = @columnName from @tableName where id = @id
select @str = show from tb_param where table_name = @tableName and column_name = @columnName and [value] = @v
return @str
end
这样写会报错,说@tableName没有声明,请高手帮忙改改!!