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 |
2revup
Posting Yak Master
112 Posts |
Posted - 2013-07-02 : 06:54:45
|
I have a CSV, which I am doing a bulk import on. To which I am creating a table see below for structure.Is there anyway that I can some how append and create a new column, the column just needs to insert an INT of '1' Is this even possible?Create TABLE Shop_Import(Cat_name VARCHAR(max) NULL,ProductID INT NULL,Manufacture VARCHAR(max) NULL,Product_Name VARCHAR(max) NULL,QTY INT NULL,Spare VARCHAR(max) NULL,Gender VARCHAR(max) NULL,Battery VARCHAR(10) NULL,Min_Age VARCHAR(10) NULL,Cost money NULL,Age VARCHAR(40) NULL,Gender_Selection VARCHAR(40) NULL,Images VARCHAR(max) NULL,Summary VARCHAR(max) NULL,Description VARCHAR(max)NULL,Weight [decimal](16, 2) NULL,Height [decimal](16, 2) NULL,Length [decimal](16, 2) NULL,Width [decimal](16, 2) NULL)GO |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
|