Hi..
Following is my table structure,
create table SampleTable1
(
Test1 int,
Test2 int,
Test3 int
)
I inserted values for three columns as (1,1,1),(2,2,2),(3,3,3)
Now i want to update both 3 columns values with the symbol of '-' and i tried with the following query as
update SampleTable1 set Test1='-',Test2='-',Test3='-' where Test1 is null and Test2 is null and Test3 is null
While executing,am getting result as "(0 row(s) affected)".
What is the wrong in my query...guide me