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)
ASP.NET Core
Certainly! Here are 10 advanced .NET Core interview questions covering various topics: 1. **ASP.NET Core Middleware Pipeline**: Explain the...
-
The error message you encountered ("DeleteService FAILED 1072: The specified service has been marked for deletion") indicates tha...
-
Transformers have shown promising results in various natural language processing (NLP) tasks, but they can also be adapted for time series ...
-
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