createprocedure proc_SelectDynamic @Idint, -- ID @LbIdint, -- 类别ID @GetFieldnvarchar(200) -- 获取字段名 AS declare@sqlnvarchar(300), @paramnvarchar(500) set@sql='SELECT '+@GetField+' FROM TEST WHERE ID = @ID AND LBID = @LBID ' set@param='@ID int, @LbId int' exec sp_executesql @sql, @param, @id, @lbid