22,210
社区成员
发帖
与我相关
我的任务
分享
update 表2
set 表2.列1=表1.列1
from 表2 inner join 表1 on 表2.id=表1.id
CREATE VIEW view_a
AS
SELECT
a.*
,b.columnName
FROM a INNER JOIN b ON a.id=b.aid
USE tempdb
GO
IF OBJECT_ID('v_t') IS NOT NULL DROP VIEW v_t;
IF OBJECT_ID('t') IS NOT NULL DROP TABLE t;
IF OBJECT_ID('tb') IS NOT NULL DROP TABLE tb;
GO
CREATE TABLE t(
id INT IDENTITY(1,1) PRIMARY KEY,
n NVARCHAR(20)
)
INSERT INTO t(n)
VALUES('a1'),('a2'),('a3')
GO
CREATE TABLE tb(
id INT IDENTITY(1,1) PRIMARY KEY,
tId INT,
bn NVARCHAR(20)
)
GO
INSERT INTO tb(tId,bn)
VALUES(1,'b1'),(2,'b2'),(3,'b3')
GO
CREATE VIEW dbo.v_t
WITH SCHEMABINDING
AS
SELECT a.id,a.n,b.bn
FROM dbo.t AS a INNER JOIN dbo.tb AS b ON a.id=b.tid
GO
CREATE UNIQUE CLUSTERED INDEX ix_v_t ON dbo.v_t(id);
GO
SELECT * FROM v_t
/*
id n bn
1 a1 b1
2 a2 b2
3 a3 b3
*/