Insert Sql Statement

#1

What is the syntax to insert a field data using a
variable.

TableName = Variable

I have a sql
Insert into TESTTABLE Item, Price From Tablename
I have a field TESTTABLE called Table, I need to include
in my insert statement to have Table = TableName.
I have tried the Set Table = TableName but got an error.

Can someone help me?
Thanks
Vina

#2

You might use dynamic SQL, try this link

http://www.algonet.se/~sommar/dynamic_sql.html

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
---
"Vina" <tvae (AT) att (DOT) net> wrote

Quote:

What is the syntax to insert a field data using a
variable.

TableName = Variable

I have a sql
Insert into TESTTABLE Item, Price From Tablename
I have a field TESTTABLE called Table, I need to include
in my insert statement to have Table = TableName.
I have tried the Set Table = TableName but got an error.

Can someone help me?
Thanks
Vina

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Insert Sql Statement

microsoft.public.sqlserver.mseq microsoft.public.sqlserver.mseq

Insert Sql Statement - 10-06-2003 , 05:08 PM

Re: Insert Sql Statement - 10-07-2003 , 09:08 PM