need help for a query that contains variables

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

need help for a query that contains variables

Author

Topic

ann06
Posting Yak Master

171 Posts

Posted - 2010-06-08 : 02:38:50

hi,
i have this simple query where i declared the columns and table names as variables like this

Declare @viewColumns NVARCHAR(254)
set @viewColumns='docno,indocno,subject'

Declare @viewTables NVARCHAR(500)
set @viewTables = 'technical_main'

select @viewColumns
from @viewTables

its showing error 'Must declare the variable '@viewTables''.
can't i do such ??
thanks and regards

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2010-06-08 : 02:44:16

Google for dynamic sql if your variables @viewColumns and @viewTables would change with time.