how to create views in sql with syntax and example

Answer Posted / ranjith reddy

CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition

Using Views
CREATE VIEW [Current Product List] AS
SELECT ProductID,ProductName
FROM Products
WHERE Discontinued=No

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain convert.tostrin?

624


What is vb.net used for?

547


Define clr?

543


What is the difference between convert.tostring and i.tostring method?

547


What is stack used for in vb. Net?

525






Name and explain some of the exclusive features which are present in vb?

545


How to run a dos command in vb.net?

609


thak you Mr Govind for replying to my question. My next question is that how to retrieve image stored in an SQL server table and assign it to any image control or picture control using VB.net

1701


What is enumerator?

557


what is intermediate language?

606


What is the difference between value and reference types?

539


What is the difference between convert.tostring and .tostring() method?

519


What is a preprocessor directive in vb.net?

538


What is break mode? What are the options to step through code?

547


Can you please explain the difference between dispose and finalize()?

498