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
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