Tag Info

New answers tagged


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