document.write("
select *
from VCustomer
SelectFromView.sql - Snippet hosted by \"Cacher\"
RAW
-- Remove sort in the select statement
 
Alter VIEW [VCustomer] 
AS
Select cus.CustomerId, refCode, CustomerName
From Customer as cus
Inner join CustomerDetails as dei on dei.CustomerId = cus.CustomerId
AlterView.sql - Snippet hosted by \"Cacher\"
RAW
");