Answer / abhinandan

create view <Viewname> as
select a as A,b as B,c as C
from <tablename>
where <whereclause{optional}> order by A

Answer / vinoth

CREATE VIEW vino (view_name)
AS
SELECT mark1 (column_name(s))
FROM stud(table name)
WHERE avg>80 (condition)

Answer / jayesh patel

CREATE VIEW <View Name> AS <Query Goes here>

Answer / 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

Answer / v.vaithyanarayanan

CREATE VIEW table_name [ ( column_name1,
column_name2, ... ) ]
AS SELECT ...

EX:
CREATE VIEW ViewOfTableA AS SELECT col1 FROM TableA

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

0 Answers  

What is intermediate langauge?

0 Answers  

What is jagged array in vb.net?

0 Answers  

Explain about jagged arrarys ?

0 Answers  

What are the objects in asp.net and tell the purpose of those objects

3 Answers   Ascent, CCS, MTBC,

How do you use two datareaders at the same time in a vb.net windows application ?

0 Answers  

How to execute VB.NET PROJECTS,VB6.0 PROJECTS AND write their test cases.Need Reply Urgently

0 Answers  

The default back end of the VB is

1 Answers   Hexaware,

what is the advantage of option strict on?

0 Answers  

Described strong typing and weak typing?

0 Answers  

What is difference between metadata and manifest?

0 Answers  

What is the top .net class that everything is derived from?

0 Answers