L
lanlan1111
Unregistered / Unconfirmed
GUEST, unregistred user!
用bulk insert命令从文件中往视图中插入数据时,如果基表中含有标识列,
则插入失败,(视图有触发器)
bulk insert tmp.dbo.vtmp
from 'c:/tmp/tmp.txt'
with
(
DATAFILETYPE = 'char',
FIELDTERMINATOR = ',',
ROWTERMINATOR = '/n',
KEEPIDENTITY,
FIRE_TRIGGERS
)
则插入失败,(视图有触发器)
bulk insert tmp.dbo.vtmp
from 'c:/tmp/tmp.txt'
with
(
DATAFILETYPE = 'char',
FIELDTERMINATOR = ',',
ROWTERMINATOR = '/n',
KEEPIDENTITY,
FIRE_TRIGGERS
)