I have a text file that has one number in it. I need to load that number into the table, but I need to add 2 more fields to it (hard-code value and the current date).
For instance: my file has 12345 in it. I need to do the following:
insert into tableA
Is it possible to do in one shot in:
BULK INSERT tableA
WITH ( ROWTERMINATOR ='' )