Sample Bulk Insert Command from a Text File into MSSQL

bulk

insert [DBName].[dbo].[Table] from 'd:\textfile.csv' with (DATAFILETYPE = 'char',FIELDTERMINATOR = ';',ROWTERMINATOR = '\n')