...

Hi Madhivanan, Is it possible to capture the csv filename into a field in the table as well. Thanks in advance, DCS...

Hi Madhivanan, Is it possible to capture the csv filename into a field in the table as well. Thanks in advance, DCS...

BULK INSERT is used to insert data to a table from a text file. Only problem with it is that it is not possible to specify the columns that you want data to be imported. For example the table has 4 columns whereas there are data for 2 columns in the tex...

Hi Naomi, Thanks for replying, U r using @SearchString = N'''' while I used :- @SearchString = N''' maybe that is the reason. I used one single quote between two single quotes and you used four single quotes....

Hi Naomi, Thanks for replying, U r using @SearchString = N'''' while I used :- @SearchString = N''' maybe that is the reason. I used one single quote between two single quotes and you used four single quotes....

Hi Naomi, How do i make it work if I want to search all the columns for the values which have single quotes in them? I tried this select @Table_Name = 't_recur', @SearchString = N''' And the error I am getting is :- Msg 102, Level 15, Stat...

Hi Naomi, How do i make it work if I want to search all the columns for the values which have single quotes in them? I tried this select @Table_Name = 't_recur', @SearchString = N''' And the error I am getting is :- Msg 102, Level 15, Stat...