YouareresponsibleforimportingdataintoSQLServer2005databases.Yourdepartmentisstartingtoreceivetextfilesthatcontainsalestransactionsfromstoresacrossthecountry.Columnsinthedataareseparatedbysemicolons.Youneedtoimportthefilesintothesalesdatabase.Whatshouldyoudo?()
A.Createacustomformatfile,specifyingasemicolonastherowterminator.
B.Usethebcpcommand,specifyingasemicolonasthefieldterminator.
C.Usethebcpcommandwiththedefaultarguments.
D.UsetheBULKINSERTstatementwiththedefaultarguments.
正确答案:参考B



