UPDATE（子查询）SET Column ='1' [英] UPDATE (subquery) SET Column='1'

问题描述

Hi

I want to update one of the columns of my table.

I have to use subquery to reach to the desired record, but it seems that we aren't allowed to use subquery in front of UPDATE.

what is the best way to update the column with subquery ?

UPDATE 	(SELECT TOP(1)* FROM (SELECT * FROM TempTable WHERE Column1='1' AND Column2='2') AS AAA )AS BBB
	
		SET Column3='1'

推荐答案

UPDATE 	TempTable
	WHERE	ColumnID = (Select	Top 1   ColumnID
				From	TempTable
				Where	Column1='1' AND Column2='2')
	SET Column3 = '1'

您好


如果您的表具有ID的唯一标识列，您可以使用以下查询：

Hi
If your table has a unique identity columns as ID, you can use from bellow query:

Declare	@RowID	As	BigInt
Set	@RowID	=	Select	Top 1   ColumnID
				From	TempTable
				Where	Column1='1' AND Column2='2'
UPDATE 	TempTable
	WHERE	ColumnID = @RowID
	SET Column3 = '1'

我希望它对你有所帮助。

I hope it's helpful for you.

你好b $ b

如果你的表有唯一的标识列作为ID ，你可以使用bellow查询：

Hi
If your table has a unique identity columns as ID, you can use from bellow query:

UPDATE 	TempTable
	WHERE	ColumnID = (Select	Top 1   ColumnID
				From	TempTable
				Where	Column1='1' AND Column2='2')
	SET Column3 = '1'

请使用此查询。

Please use from this query.

这篇关于UPDATE（子查询）SET Column ='1'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！