Tag Info

New answers tagged

0

The INSERT command comes in two flavors (this is for SQL Server but there's a good chance it'll be the same for Access, too): (1) either you have all your values available, as literals or SQL Server variables - in that case, you can use the INSERT .. VALUES() approach: INSERT INTO dbo.YourTable(Col1, Col2, ...., ColN) VALUES(Value1, Value2, @Variable3, ...



Top 50 recent answers are included