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
What are the different variables in vb.net?
What are the different types of Lock available in Visual Basic?
How do you define a read only property in a class module?
Explain some of the exclusive features which are present in vb?
described weak typing?
What is the difference between manifest and metadata?
What is the purpose of objects present in asp.net?
What are the assembly entry points?
What is difference between metadata and manifest?
Which control is an example of an object in vb net?
Explain option strict?
What are all the differences between dispose and finalize()?
What are the difference between dispose(), close(), exit(), end()?
Explain the difference between dispose and finalize()?
What are the differences between c# and visual basic.net?