Answer / ajay sharma

UPDATE mytable set mycolumn = (mycolumn + 1)%2

Answer / vicky

Update test01 Set num =(case num when 1 then 0 when 0
then 1 else 3 end)

Answer / shaheem ck

UPDATE <tablename>
SET <columnname> = DECODE(<columnname>,0,1,
1,0,
<columnname>);

Answer / madhu sudhan g

Hiii Lets take a table Test contains one field No having 8
rows in that 4 rows are with 0's and 4 rows with 1's to update

Update Test
SET No=case when 1 then o
else 1
ENd

Answer / vernold

Update Table1 Set Column = case when Column = 1 then 0
when column = 0 then 1

Answer / krishna reddy l

update example set column1 = case when column1=0 then 1
when column1=1 then 0 end

Answer / vicky saini

Update (tablename) set (coulmn name)=1 where (coulmn name)
=0

Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

1 Answers  

How to copy the tables, schema and views from one sql server to another?

0 Answers  

How do you drop an index?

0 Answers  

What do you mean by authentication modes in sql server?

0 Answers  

What do you mean by a dependent functionality in a build?

0 Answers   HCL,

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

4 Answers   IBM,

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

2 Answers   IBM, TCS,

What is sql language?

0 Answers  

Is it important for a database administrator to understand the operating system and file access?

0 Answers  

What is the need for group functions in sql?

0 Answers  

what is for foreign key ??

4 Answers   CarrizalSoft Technologies, Sabic,