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 sealed class?

0 Answers  

How a base class method is hidden?

0 Answers  

What are the types of generations in garbage collector?

0 Answers  

Explain cls?

0 Answers  

What are all the differences between dispose and finalize()?

0 Answers  

write a program to develop a graphic user interface application of marks book with students names and their names.the program should show the following options main menu,add student details,display student details,maximum mark and minimum mark.

0 Answers   College School Exams Tests,

Explain an assembly?

0 Answers  

Explain the difference between vb 6 and vb.net?

0 Answers  

How to run a dos command in vb.net?

0 Answers  

Name some of the features of C# which are not present in VB.NET?

0 Answers  

Give the sample code for ItemStockGroupwise Report?

1 Answers   CTS,

what is the base class of .net?

7 Answers