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

Explain about visual basic?

0 Answers  

Explain enumerator?

0 Answers  

What is an arraylist?

0 Answers  

What is the difference between Abstract Classes and Interfaces? Give the answer as a table format....

5 Answers  

What is a static class?

0 Answers  

What is the advantages of VB.NET?

0 Answers   NA,

how to send data to exe file? my code has a button when i press it, an exe file will open. how can i send data as input to the exe file?

2 Answers  

Advantage of vb.net over vb ?

6 Answers   Digital GlobalSoft,

What is "Polymorphism" and what are Polymorphism in VB.Net?

2 Answers  

What are the difference between dispose(), close(), exit(), end()? When do we use them?

0 Answers  

I want to sample Hotel management project in vb.net because still now i am doing that project for small hotel....so please send me my email id is jmuthu_pearls@yahoo.com...

4 Answers   Sapphire Comfort Hotel, TATA,

what is difference between web.config and machine.config and where it will be ?

0 Answers