TSQL de View ile çalışma

x

x

USE [Chinook]
GO

CREATE VIEW [AbumlerArtistler]
AS
SELECT     Album.Title, Artist.Name
FROM         Album INNER JOIN
                      Artist ON dbo.Album.ArtistId = Artist.ArtistId
GO

View düzenlemek için

USE [Chinook]
GO

ALTER VIEW [AbumlerArtistler]
AS
SELECT     Album.AlbumId, Album.Title, Artist.Name
FROM         Album INNER JOIN
                      Artist ON dbo.Album.ArtistId = Artist.ArtistId
GO

x

x