declare @temp table
(
Id int identity(1,1) not null,
alpha nvarchar(50)
)
insert @temp select null
insert @temp select null
insert @temp select null
select * from @temp
declare @temp1 table
(
Id int identity(1,1) not null,
alpha nvarchar(50)
)
insert @temp1 select 'A'
insert @temp1 select 'B'
insert @temp1 select 'C'
select * from @temp1
update @temp set alpha=t1.alpha
FROM @temp as t inner join @temp1 as t1 ON t.id=t1.id
select * from @temp
Thursday, November 8, 2012
update table from another table or same table using inner join
Subscribe to:
Post Comments (Atom)
can you please explain me Backpropagation & Gradients in layman language as simple as possible
Absolutely! Let’s break down backpropagation and gradients in the simplest possible way , like we’re teaching a curious 10-year-old. 🎯...
-
The error message you encountered ("DeleteService FAILED 1072: The specified service has been marked for deletion") indicates tha...
-
may be you need to show serial number in your rdlc report then you can use following syntax for showing 1,2,3... continuous on in table fie...
-
The error message you're seeing indicates that the "global using directive" feature is currently unsupported in the version o...
No comments:
Post a Comment