Collections:
Using SELECT Statements on Views in SQL Server
Can SELECT Statements Be Used on Views in SQL Server?
✍: FYIcenter.com
Select (query) statements can be used on views in the same way as tables. The following tutorial exercise helps you creating a view and running a query statement on the view:
CREATE VIEW myLinks AS SELECT * FROM fyi_links WHERE url LIKE '%fyi%' GO SELECT tag, counts, url, created FROM myLinks ORDER BY counts DESC GO tag counts url created DBA 972 dba.fyicenter.com 2007-05-19 SQA 728 sqa.fyicenter.com 2007-05-19 DEV 120 dev.fyicenter.com 2006-04-30
2016-10-26, 1172👍, 0💬
Popular Posts:
How To Create a View on an Existing Table in SQL Server? If you want to a view on an existing table,...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Create a Table in a Specific Tablespace in Oracle? After you have created a new tablespace, y...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...