SQL Bulk Insert
SQL for bulk insert into a table: BEGIN declare @s varchar(400) set @s = ‘BULK Insert my_temp_table FROM ”’ + @file_name + ”’ WITH ( FIELDTERMINATOR = ”,”, ROWTERMINATOR = ”\n”, FIRSTROW = 1 )’ print @s exec(@s) END
SQL for bulk insert into a table: BEGIN declare @s varchar(400) set @s = ‘BULK Insert my_temp_table FROM ”’ + @file_name + ”’ WITH ( FIELDTERMINATOR = ”,”, ROWTERMINATOR = ”\n”, FIRSTROW = 1 )’ print @s exec(@s) END
Let’s say…one of your DB log file got too large and u need to make some space in your hard disk very quickly. So, u like to delete a .ldf file/log file of a database of MS SQL server. First, you need to close any SQL server client tool that is running (i.e. SQL Server Management Studio), … More Deleted database log(.ldf) file of SQL Server? Need to Restore database?