Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
how to update column value in sqlserever
Devendra Kumar
Jun 6 2016 8:27 AM
293
Reply
hi friends please help me :
i want to update my product price
Select
a.Category_Name, b.Price,c.Qty,b.Price_Updated_by,
case when
b.Price_Updated_by = '
Product
'
then
b.Price*c.Qty
else
a.cat_price*c.Qty
end
as[TotalPrice],
i want i check
case when
a.Category_Name
=
'Bedsheet Tapestry'
then
b.Price
=
'60'
,
i want b.price =60 when category name
Bedsheet Tapestry
what it is possible please help
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Why the tab open I'm not see record, but when i query
Encryption and Decryption