Learn how to create VIEW in SQL Server. Below is a basic Example.
USE [MyDB]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[View_Parent]
AS
SELECT P.Id
,P.Name
FROM Parent P
GO
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[View_Parent]
AS
SELECT P.Id
,P.Name
FROM Parent P
GO
0 Comments