How to Search the entier DataBase

bex · January 15th, 2009, 06:37 AM

Now i have stumbeld into onother problem, i need to insert into 2 tables at the same time the same data.

Code:

Dim con AsNew SqlConnection(ConfigurationManager.ConnectionStrings("test").ConnectionString)
Dim cmdd AsNew SqlCommand("INSERT INTO " & l & " Campaign(Template, CampaignName) VALUES(@Template, @CampaignName)", con)
cmdd.Parameters.Add("@Template", Data.SqlDbType.VarChar, 50).Value = Me.ListBox1.SelectedValue
cmdd.Parameters.Add("@CampaignName", Data.SqlDbType.VarChar, 50).Value = s
 
con.Open()
cmdd.ExecuteNonQuery()
con.Close()

" & l & " is table 1 when i try to run the statement i get
Incorrect syntax near 'Campaign'.

alliancejhall · January 15th, 2009, 08:06 AM

You issues is due to your table being named Table 1 instead of Table1 or Table_1

you can't have a space in the name because the server will see it as if you want to represent the table as 1

so it would be 1.campaign which still won't work because your table name is Table 1 not Table.

I hope this makes sense. just rename the table to Table1 or Table_1

bex · January 15th, 2009, 08:52 AM

I know that spaces are not wellcomed in sql but that is not the isue,
i dont know what goes betwin the tables?
ex
INSERT INTO Table1 Campaign(Template, CampaignName) VALUES(@Template, @CampaignName)", con

and i have to use " & l & " cos that is what makes Table 1 into Table1

Old Pedant · January 15th, 2009, 06:41 PM

You can *NOT* insert into two tables with a single SQL statement.

Period. End. Done.

You MUST use two SEPARATE queries.

And Jason (Alliance) is wrong: You *CAN* have a space in a table name. You just have to "escape" the name in your SQL, as for example
INSERT INTO "Table 1" ...
(assuming you use the default meaning of quotes in SQL Server 2005 and 2008)
or maybe
INSERT INTO [Table 1] ...