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, 2017👍, 0💬
Popular Posts:
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...