How to use multiple update queries in SQL Server

Question

I want to update Data_type where Data_Type contains Null or strings except D if there is any string how could i code it

Update Table_Name
Set Data_Type='D'
Where Data_type is Null 
   or Data_type = ' ' or like Data_type %[A-C]% or Data_Type %[e-z]%
Go
--

Squirrel · Accepted Answer · 2018-10-13 04:13:28Z

1

your syntax is wrong. Should be

Update Table_Name
Set    Data_Type = 'D'
Where  Data_Type <> 'D'
and    src_hm    <> 1
and   (
       Data_type is Null 
or     Data_type = ' ' 
or     Data_type like %[A-C]% 
or     Data_Type like %[e-z]%
      )

edited Oct 13, 2018 at 4:13

answered Oct 13, 2018 at 3:56

Squirrel

24.8k5 gold badges41 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nikhil More Over a year ago

Cool thanks man and if i want to put this into procedure if Data_type <> D then update and src_hm <>1 then update how can i code this ?

Collectives™ on Stack Overflow

How to use multiple update queries in SQL Server

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related