Update record by substracting value using SQL Server

sat

SOLVED CLOSED ACTIVE ANSWERED
User: sat
Posted: on Oct 20, 2016 02:10 AM
Forum: SQL Server
Answer: 1
Views: 3654

Hi. I have a gridview as under:

Id Name Entitlement

1 Suresh D 2490

2 Anita R Sub 3500

3 George T 1800

On the same page I also have a Label where I have a fixed value as 100.

I want to update Entitlement column values by deducting 100 in all the rows. Is it possible to do so? If yes, please guide me on the Sql Update Query Statement. Thanks. Sat

Download FREE API for Word, Excel and PDF in ASP.Net

AnandM

0 1

Reply
ANSWER
User: AnandM
Replied: on Oct 20, 2016 02:24 AM
Modified: on Oct 20, 2016 02:24 AM
Report

Hi sat,

Please refer below SQL Query

SQL

DECLARE @Records AS TABLE (Id INT, Name VARCHAR(30), Entitlement INT)
INSERT INTO @Records VALUES (1,'Suresh D',2490)
INSERT INTO @Records VALUES (2,'Anita R Sub',3500)
INSERT INTO @Records VALUES (3,'George T',1800)							 
SELECT * FROM @Records
DECLARE @labelValue INT
SET @labelValue = 100
UPDATE @Records SET Entitlement = Entitlement - @labelValue
SELECT * FROM @Records

Before Deduction Output

Id	Name	Entitlement
1	Suresh D	2490
2	Anita R Sub	3500
3	George T	1800

After Deduction Ouput

Id	Name	Entitlement
1	Suresh D	2390
2	Anita R Sub	3400
3	George T	1700

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Update record by substracting value using SQL Server

Company

Explore

Follow us

Contact Us