Interested to Buy Any Domain ? << Click Here >> for more details...
how to update a null value field in sql server
eg
a table contains 3 fields id,name,salary
and 3 records
salary of 1 record is null
i want update the nullfield
111 arun 300
112 ddd 200
113 ttt null
i want to update table with add 100 to every record include null
after updation
the recrds should be
111 arun 400
112 ddd 300
113 ttt 100
- 6 Answers
- 17711 Views
- ABC, HCL, I also Faced
- E-Mail Answers
Answer Posted / dinesh sharma
It Simple
Just Write Down The Query
update table_Name set salary=100 where salary is null
| Is This Answer Correct ? | 12 Yes | 28 No |
Post New Answer View All Answers
How do I schedule a sql server profiler trace?
What do you mean by cardinality?
how to create “alternate row colour”?
Can I use sql azure as a backup with log shipping or database mirroring?
Can we insert data into view sql server?
Does order by actually change the order of the data in the tables or does it just change the output?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
What is trace flag in sql server?
Is BCNF better than 2NF & 3NF? Why?
What are “lock” hints?
Write a sql query to sort on different column name according to the parameters passed in the function?
Where are sql server usernames and passwords stored in the sql server?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
What is buffer cash in sql server?
