Collections:
CREATE VIEW - Creating a View on an Existing Table in SQL Server
How To Create a View on an Existing Table in SQL Server?
✍: FYIcenter.com
If you want to a view on an existing table, you can use the CREATE VIEW statement in a simple syntax:
CREATE VIEW view_name AS SELECT ...
The tutorial exercise below shows you how to create a view to represent sub set of data stored in fyi_links table:
USE FyiCenterData; GO CREATE VIEW fyi_links_top AS SELECT id, counts, url FROM fyi_links WHERE counts > 100; GO SELECT TOP 10 * FROM fyi_link_top; GO id counts url ------ ------- ----------------------------------------- 7600 237946 eyfndw jdt lee ztejeyx l q jdh k 19437 222337 eypx u x 55924 1877 eyq ntohxe i rtnlu riwaskzp cucoa dva c 63742 121330 ezdaeh mmgmo vaai meytbjjv f jixfsdjw pw 92455 945262 ezlmyenrw dyeb 36391 41386 f 87433 977726 f 7180 559314 f kqbqlej s xixuurcgg lh r dqqvqsstxw 2252 702033 f bkh jy sqrkttuoarxmfp idqyhyy tme d 1228 146283 f m asukh
2016-11-05, 1573👍, 0💬
Popular Posts:
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How Can Windows Applications Connect to Oracle Servers in Oracle? A Windows application can connect ...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...