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...
-
replace html of a div using jquery this is simple . just use .html() method of jquery to set new html for a div . $ ( "#divID&q...
-
declare @ProductIds nvarchar(50)='18,19' SELECT * FROM products Where (',' + @ProductIds +',' LIKE '%,' ...
No comments:
Post a Comment