Question about T-SQL - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Question about T-SQL

Question about T-SQL# Database - 数据库

o*s2000-08-21 07:08

1 楼

We have the following statement, which SQL Server does not
accept due to grammar problem:
declare @product varchar(32)
select @product = "product"
select * from @product
Is there any way we can select the record from a table whose
name is provided using a variable?
Thanks a lot.

s*c2000-08-21 07:08

2 楼

you can use ODBC to solve this problem.

r*r2000-08-21 07:08

3 楼

declare @sqlcmd varchar(1024),
@product varchar(32)
select @procut = 'product'
select @sqlcmd = 'select * from ' +
quoatename(@product,'''')
exec(@sqlcmd)
that's it.

【在 o*****s 的大作中提到】

: We have the following statement, which SQL Server does not
: accept due to grammar problem:
: declare @product varchar(32)
: select @product = "product"
: select * from @product
: Is there any way we can select the record from a table whose
: name is provided using a variable?
: Thanks a lot.