Posted by akej via SQLMonster.com on 09/30/58 11:16

Hi, i have table with 15 columns

CREATE TABLE [dbo].[myTable] (
[m] [bigint] PRIMARY KEY ,
[c1] [bigint] NULL ,
[c2] [bigint] NULL ,
[c3] [bit] NULL ,
[c4] [tinyint] NULL ,
[c5] [nvarchar] (50) NULL ,
[c6] [bit] NULL
................
...................

now i want to run BULK INSERT from file that consist only values for first
column e.g.

22222222222
33333333333
44444444444
............
............

and i need that other columns will sets to it's default values i.e. NULL


Any ideas ?????

Thanks

--
Message posted via http://www.sqlmonster.com

• Next in forum: How long is a SQL statement allowed to be?
• Prev in forum: Newbie: Transfering databases from different servers
• Thread view: BULK INSERT Question

[Reply to this message]