带参数的select问题 请教各位

[BOBI1201]

select @Numbc = 序号,@HouseNumbbc = 栋号,@RoomNumabc = 房号,@Namebc = 姓名,@Stylebc = 类型,@Areabc = 面积,@Pricebc = 单价,@Chargeofmonthbc = 月应收费用,@Estatebc = 缴费状态 from @HouseNumabc order by 序号


执行时提示必须申明变量@HouseNumabc 但是我已经定义了 我没有分了 请各位帮帮忙
下面是整个存储过程

create procedure sp_rushRoomNum(
@Status int output,
@Errmsg VARCHAR(255) output,
@Numbc int output,
@HouseNumbbc varchar(10) output,
@RoomNumabc varchar(10) output,
@Namebc nvarchar(10) output,
@Stylebc nvarchar(10) output,
@Areabc float(8) output,
@Pricebc float(8) output,
@Chargeofmonthbc varchar(53) output,
@Estatebc nvarchar(10) output,
@HouseNumabc varchar(10)

)
AS

SET NOCOUNT ON

/*DECLARE @TmpSQL NVARCHAR(4000)*/

SET @Status=0
SET @Errmsg=''
select @Numbc = 序号,@HouseNumbbc = 栋号,@RoomNumabc = 房号,@Namebc = 姓名,@Stylebc = 类型,@Areabc = 面积,@Pricebc = 单价,@Chargeofmonthbc = 月应收费用,@Estatebc = 缴费状态 from @HouseNumabc order by 序号


If @@ROWCOUNT<>0 Begin
Set @Status=-2
SET @Errmsg='Room existed!'
END

IF @@Error<>0 BEGIN
SET @Status=-1
SET @ErrMsg='数据库异常错误，请稍后再试'
END

SET NOCOUNT OFF
/*select * from dh*/



GO

[happygong]

需要赋值，因为是OUTPUT类型的参数

[BOBI1201]

@HouseNumabc varchar(10) 这个不是output类型的参数啊 就是他有问题

[BOBI1201]

怎么样动态查询 能具体一点吗

[BOBI1201]

我这个表的名字是外部程序传入的参数 那要怎么做才能达到目的

[happygong]

动态生成一个SQL语句,然后使用sp_executesql

[happygong]

USE Northwind
DECLARE @SQLString NVARCHAR(500)

/* Set column list. CHAR(13) is a carriage return, line feed.*/
SET @SQLString = N'SELECT FirstName, LastName, Title' + CHAR(13)

/* Set FROM clause with carriage return, line feed. */
SET @SQLString = @SQLString + N'FROM Employees' + CHAR(13)

/* Set WHERE clause. */
SET @SQLString = @SQLString + N'WHERE LastName LIKE ''D%'''

EXEC sp_executesql @SQLString

[BOBI1201]

up

[zonelive]

select语句后面的表名不能用变量，此处需用动态查询就行了