What''s wrong with this ?

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Farrell Keough SSCoach Points: 17414 More actions · Answer 1

SELECT @t will give you a result.

SELECT * FROM @t is treating @t as a Table Variable...

I wasn't born stupid - I had to study.

deepforest SSCommitted Points: 1780 More actions · Answer 2

SSCommitted

Points: 1780

April 4, 2006 at 1:57 pm

@t contains table name ('Admit')

Farrell Keough SSCoach Points: 17414 More actions · Answer 3

Is this what you want?

DECLARE @t TABLE( Field1 varchar(10))

INSERT INTO @t VALUES( 'Admit')

SELECT * FROM @t

I wasn't born stupid - I had to study.

rsharma SSCarpal Tunnel Points: 4865 More actions · Answer 4

You can do:

use pubs

go

declare @t varchar(8)

set @t='authors'

exec ('select * from '+@t+'')

or

use pubs

go

declare @t varchar(8), @cmd nvarchar(100)

set @t='authors'

set @cmd = N'select * from '+@t+''

exec sp_executesql @cmd

Doing the way that you are trying to do, you cannot select from a variable unless it is a table variable.

deepforest SSCommitted Points: 1780 More actions · Answer 5

"you cannot select from a variable unless it is a table variable"

That's what I wanted to hear, thnx.