Copy&Create tables. (1 Viewer)

[accessman2]

Hi:
I want to do the following T-SQL, but it seems not correct. Can anybody correct me?
declare @bp table
set @bp = getdate()
select * into [@bp] from [Invoice Data]

Thanks.

 

[SQL_Hell]

Hi there

You seem to be declaring a table variable but not giving it any columns, how many columns are in table invoice data?

Are you sure you want to ue a table variable as opposed to a temporary table? Do you know the pros and cons of each?

 

[WayneRyan]

am,

AFAIK, you can't use variables in the place of database names or table names.

sp_ExecuteSQL 'select * into ' + @bp + ' from [Invoice Data]'

Wayne