存储过程的参数能传递表的字段名吗?
CREATE PROCEDURE CountPriority
@hb nvarchar
AS
SELECT dbo.lidifenzhi.TreeName,
dbo.lidifenzhi.@hb * (dbo.lidiquanzhong.Orention / 100.0)
AS fenzhi
FROM dbo.lidifenzhi INNER JOIN
dbo.lidiquanzhong ON
dbo.lidifenzhi.TreeName = dbo.lidiquanzhong.TreeName
ORDER BY fenzhi DESC
GO
dbo.lidifenzhi.@hb 处出错