2012年2月25日星期六

disabling identity with bulk insert

hi,
can identity be disabled with the bulk insert operation.
if so then how is it to be done?
thnks
anu
use WITH KEEPIDENTITY as an option if usign BULK INSERT, -E is using bcp.
--
Mary Bray [SQL Server MVP]
Please only reply to newsgroups
"Anuradha" <Anuradha@.discussions.microsoft.com> wrote in message
news:237F7136-AEE5-440F-8495-BFEB475F477F@.microsoft.com...
> hi,
> can identity be disabled with the bulk insert operation.
> if so then how is it to be done?
> thnks
> anu

没有评论:

发表评论