--try:CREATE FUNCTION Getjiage10
(
@product_id int,
@db0 char(50)
)
RETURNS float AS
BEGIN
declare @rtnjiage0 float
declare @sql nvarchar(255) set @sql=N'SELECT @rtnjiage0=jiage FROM ['+@db0+'] WHERE id = "+@product_id+"'
exec sp_executesql @sql,N'@rtnjiage0 float output',@rtnjiage0 outputreturn @rtnjiage0
END
(
@product_id int,
@db0 char(50)
)
RETURNS float AS
BEGIN
declare @rtnjiage0 float
declare @sql nvarchar(255) set @sql=N'SELECT @rtnjiage0=jiage FROM ['+@db0+'] WHERE id = "+@product_id+"'
exec sp_executesql @sql,N'@rtnjiage0 float output',@rtnjiage0 outputreturn @rtnjiage0
END
想要赋值给变量,得用OUTPUT参数执行动态SQL