|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-03-15 : 08:19:46
|
| Richard writes "Is is possible to use an Insert statement but rather than having the actual values included, use variables that pull data from a file?INSERT INTO EmployeeT(CardID, OtherID, HomeDivision, HomeDepartment, PayPeriod, SchedNo, RoundPolicy, OTRUleGroup, FirstName, MiddleName, LastName, Active, eTimeProfile)VALUES('5', '105-55-1050', '1', '55', 'mo', '1', '1', '1', 'Tony', 'E', 'Rockette', 1, 'standard')INSERT INTO EmployeeT(CardID, OtherID, HomeDivision, HomeDepartment, PayPeriod, SchedNo, RoundPolicy, OTRUleGroup, FirstName, MiddleName, LastName, Active, eTimeProfile)VALUES('X1, X2, X3, X4, X4, X6, X7, X8, X9, X10, X11, X12, X13)Thanks" |
|
Inserting data 