34,594
社区成员
发帖
与我相关
我的任务
分享
use tempdb
GO
IF OBJECT_ID('t') IS NOT NULL
DROP TABLE t
GO
CREATE TABLE t(
id INT IDENTITY(1,1) PRIMARY KEY,
[name] NVARCHAR(10) NOT NULL,
[birthday] DATETIME NOT NULL
)
GO
INSERT INTO t([name],[birthday])
SELECT '小明','1990-01-01'
UNION ALL
SELECT '小红','1995-08-01'
GO
-- 以上为测试表及测试数据
--创建视图
IF OBJECT_ID('view_t') IS NOT NULL
DROP VIEW view_t
GO
CREATE VIEW view_t
AS
SELECT id
,[name]
,[birthday]
,DATEDIFF(YEAR,birthday,GETDATE()) AS age
FROM t
GO
--查看视图
SELECT * FROM view_t
/*
id name birthday age
1 小明 1990-01-01 31
2 小红 1995-08-01 26
*/
CREATE VIEW [dbo].[V_Bid]
AS
select ....