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
Showing posts with label update table from another table or same table using inner join. Show all posts
Showing posts with label update table from another table or same table using inner join. Show all posts
Thursday, November 8, 2012
update table from another table or same table using inner join
Subscribe to:
Posts (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...
-
replace html of a div using jquery this is simple . just use .html() method of jquery to set new html for a div . $ ( "#divID...
-
declare @ProductIds nvarchar(50)='18,19' SELECT * FROM products Where (',' + @ProductIds +',' LIKE '%,' ...