ID 時間 壓力 濕度 折算
1 time1 A 30 1%
2 time2 B 31 2%
3 time3 C 32 3%
4 time4 D 33 4%
5 time5 E 34 5%
6 time6 F 35 6%
查找time2 并替換壓力、濕度、折算為1
2 time2 1 1 1
uj5u.com熱心網友回復：
USE tempdb
GO
IF OBJECT_ID('dbo.[t]') IS NOT NULL
DROP TABLE dbo.[t]
GO
CREATE TABLE dbo.[t](
[ID] NVARCHAR(MAX)
,[時間] NVARCHAR(MAX)
,[壓力] NVARCHAR(MAX)
,[濕度] NVARCHAR(MAX)
,[折算] NVARCHAR(MAX)
)
GO
SET NOCOUNT ON
INSERT INTO dbo.[t] VALUES(N'1',N'time1',N'A',N'30',N'1%')
INSERT INTO dbo.[t] VALUES(N'2',N'time2',N'B',N'31',N'2%')
INSERT INTO dbo.[t] VALUES(N'3',N'time3',N'C',N'32',N'3%')
INSERT INTO dbo.[t] VALUES(N'4',N'time4',N'D',N'33',N'4%')
INSERT INTO dbo.[t] VALUES(N'5',N'time5',N'E',N'34',N'5%')
INSERT INTO dbo.[t] VALUES(N'6',N'time6',N'F',N'35',N'6%')
------------ 以上為測驗表及測驗資料 --------------
UPDATE t
SET 壓力='1',
濕度='1',
折算='1'
WHERE 時間='time2'
SELECT * FROM t
/*
ID 時間 壓力 濕度 折算
1 time1 A 30 1%
2 time2 1 1 1
3 time3 C 32 3%
4 time4 D 33 4%
5 time5 E 34 5%
6 time6 F 35 6%
*/
uj5u.com熱心網友回復：
萬分感謝，已測驗，可用轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/269872.html
標籤：基礎類
上一篇：求一個工時查詢思路