SQL Server中创建视图索引

--表名包含模式名。 
--包含 WITH  SCHEMABINDING 语句 

CREATE VIEW dbo.v_Customer WITH SCHEMABINDING AS  
SELECT  CustomerID, CompanyName, FirstName, LastName, Picture   
FROM  dbo.Customers

编程技巧