Collections:
Creating a View with Data from Another View in SQL Server
Can You Create a View using Data from Another View in SQL Server?
✍: FYIcenter.com
Can You Create a View with Data from Another View? The answer is yes. A view can be used as a table to build other views. The tutorial exercise below shows you how to create a view using data from another view:
USE AdventureWorksLT; GO CREATE VIEW SalesOrderTop AS SELECT SalesOrderNumber, TotalDue, CompanyName FROM SalesOrderView WHERE TotalDue > 10000.0 GO SELECT TOP 10 * FROM SalesOrderTop; GO SalesOrderNumber TotalDue CompanyName ---------------- ----------- ------------------------------ SO71780 42452.6519 Nearby Cycle Shop SO71782 43962.7901 Professional Sales and Service SO71783 92663.5609 Eastside Department Store SO71784 119960.824 Action Bicycle Specialists SO71796 63686.2708 Extreme Riding Supplies SO71797 86222.8072 Riding Cycles SO71832 39531.6085 Closest Bicycle Store SO71845 45992.3665 Trailblazing Sports SO71858 15275.1977 Thrilling Bike Tours SO71897 14017.9083 Paints and Solvents Company
⇒ Deleting a Table That Is Used by a View in SQL Server
⇐ Creating a View with Data from Multiple Tables in SQL Server
2016-11-05, 1475🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...