ARTICLE DETAIL

建站实战干货

来自一线的建站与推广经验沉淀,每一条都经过真实交付验证。

Sql Server 视图

2026/10/1 3:28:42 拓冰建站 浏览量
Sql Server 视图

USE [数据库名称]
GO

/****** Object:  View [dbo].[视图名称]    Script Date: 2024/2/19 10:08:13 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[视图名称:V_XXXXX]
AS

SELECT FILED1, FILED2, FILED3, FILED4
FROM dbo.表名xx  WITH (NOLOCK)
WHERE 1=1

GO