Son Haberler
Anasayfa / SQL SERVER / Sql Fonksiyonlar / Sql View Örnekleri

Sql View Örnekleri

select top 2 * from dbo.Customers
select top 2 * from orders
select top 2 * from [order details] select top 2 * from dbo.Products
select top 2 * from dbo.Employees

create view SalesDetails
AS
–CustomersName — ProductName — Quantity
select E.FirstName +’ ‘+ E.LastName as ‘Full Name’
,C.ContactName , P.ProductName , OD.Quantity
from [Order Details] OD inner join Orders O
on OD.OrderID = O.OrderID
inner join Customers C
on O.CustomerID = C.CustomerID
inner join Employees E
on O.EmployeeID = E.EmployeeID
inner join Products P
on OD.ProductID = P.ProductID
select * from SalesDetails

sp_help SalesDetails

sp_helptext SalesDetails

sp_depends SalesDetails

select * from INFORMATION_SCHEMA.TABLES
where table_name = ‘SalesDetails’

select * from INFORMATION_SCHEMA.VIEWS
where table_name = ‘SalesDetails’
create view AmericanCustomers
AS
select * from customers
where country = ‘usa’

select * from AmericanCustomers

alter table customers
add MobilePhone varchar(15) null

select * from customers

sp_depends AmericanCustomers

create view OgretmenDers
as
select O.Adi + ‘ ‘ + O.Soyadi as ‘OgretmenAdi’
,D.DersAdi
from Ogretmenler O inner join Dersler D
on O.DersID = D.DersID

select * from OgretmenDers

sp_refreshview AmericanCustomers

sp_depends AmericanCustomers

select * from AmericanCustomers

create view UKCustomers
with encryption
as
select * from customers
where country = ‘uk’
select * from UKCustomers
sp_depends UKCustomers
sp_helptext UKCustomers
select * from INFORMATION_SCHEMA.VIEWS
where table_name = ‘UKCustomers’
select * from ogretmenler
select * from ogretmenders

drop view OgretmenDers

create view OgretmenDers
with schemabinding
as
select O.Adi + ‘ ‘ + O.Soyadi as ‘OgretmenAdi’
,D.DersAdi
from dbo.Ogretmenler O inner join dbo.Dersler D
on O.DersID = D.DersID
select * from OgretmenDers

delete from dersler
where dersid = 7

sp_helptext OgretmenDers

drop table ogretmenler

alter view OgretmenDers
as
select O.Adi + ‘ ‘ + O.Soyadi as ‘OgretmenAdi’
,D.DersAdi
from dbo.Ogretmenler O inner join dbo.Dersler D
on O.DersID = D.DersID

create view BrazilianCustomers
as
select * from customers
where country = ‘Brazil’
with check option

update BrazilianCustomers
set country = ‘Turkey’
where customerID = ‘FAMIA’

select top 2 * from employees
select top 2 * from dbo.EmployeeTerritories
select top 2 * from dbo.Territories
select top 2 * from region

Hakkında karyelist

Ayrıca Buna Bakabilirsiniz

T-SQL : Birleşik adı soyadı alanını,ad bir kolon soyad bir kolon ayırma

T-SQL : Birleşik adı soyadı alanını,ad bir kolon soyad bir kolon ayırma T-SQL : Birleşik …

Bir Cevap Yazın

E-posta hesabınız yayımlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir