CREATE PROC P_user
@name VARCHAR(50)
AS
DECLARE @sql VARCHAR(1000)
SET @sql ='SELECT sum('+@name+') FROM #target'
EXEC (@sql)
DECLARE @sql VARCHAR(1000)
SET @sql ='select * into #target from users
exec P_user '+''''+'city_id'+''''
EXEC(@sql)
存储过程可以引用在同一个字符串中定义的临时表