Category Archives: SQL, Database

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                                                                                       … Continue reading

Posted in SQL, Database | Leave a comment

Deleted database log(.ldf) file of SQL Server? Need to Restore database?

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 … Continue reading

Posted in SQL, Database | 3 Comments