Wednesday, December 18, 2013

IN SQL update null value

create database jitendra

create table tblEmp
(
eid int identity,
 int
)


insert into tblEmp(salry) values(100)
insert into tblEmp(salry) values(1002)
insert into tblEmp(salry) values(1020)
insert into tblEmp(salry) values(null)
insert into tblEmp(salry) values(100)
insert into tblEmp(salry) values(125)

select * from tblEmp


update tblEmp set salry=CONVERT(INT,salry,10)+200

update tblEmp set salry = case when salry IS not null  then  salry+898
                               when salry IS null then 200
                              end

No comments:

Post a Comment