Thanks very much. I have exported data to CSv files using BCP sucessfully :).

Can anyone please let me know the process need to follow to import data from csv file...

Hi , Thanks for your replies.

Please Ignore my example if it's wrong.

Can anyone please providers a example or sample for

1)How can I export data from DB tables to CSV file...

Thanks very much fo r the reply.

I did something similar, I have achived it using Return true and Return false.

Thanks, Paul

Hi,

Thanks for your reply.

Why I am trying to use EXISTS ? This is where things are getting interesting.

...

HI,

Waht am I trying to accomplish , with the code I posted ?

First I am updating the Rows that are common in both TestD(Destination) and...

Thanks for all your time.

Nope, the above loig in not working either . It giving an error Msg 4104, Level 16, State 1, Line 1

"UPDATE TestD

SET TestD.cola=testS.col1,

TestD.colb=testS.col2

...

Thank you!

Hi

Thanks, for your reply.

Hi ,

Thanks to you all for all your replis.

Thanks to you all for all your inputs.

my req is :

If A=null

execute stored prod 1

else

check If A=c

execute stored prod 1

meaning, if the column value is null (this is null...