Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Raymond
Starting Member
2 Posts |
 Posted - 2008-04-27 : 09:47:25
|
Hello,I have a table_A with fields Val_A,Val_B and Val_C,I wish to input a values ('Paper',2,'pcs') then ('Towel',5,'Roll') and ('Wax',10,'box').I dont want to insert the whole table values but instead, inserting a specific value that I will define. Assuming that each value is a constant. How will it be done? |
|
|
Raymond
Starting Member
2 Posts |
Posted - 2008-04-27 : 22:12:51
|
| To clarify the situation, I am using ODBC, Microsoft Access Driver. Where Update, Procedure, Insert, Delete and Select are the expected beginning statement.I can't use the format below, it doesnt work:INSERT INTO Table_A(Val_A,Val_B,VAL_C)SELECT 'Paper',2,'pcs' UNION ALLSELECT 'Towel',5,'Roll' UNION ALLSELECt 'Wax',10,'box'It display that there is an error in "pcs' UNION ALLSELECT 'Towel"What are other method to do this, if this method is not applicable? |
 |
|
|
|
|
|
|
|
Multiple insert with constant value...