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 difference between namespace and assembly?

0 Answers  

What is the differnce between managed code and unmanaged code?

0 Answers  

What is VB.Net?

3 Answers   Ksb,

Which control is an example of an object in vb net?

0 Answers  

How many languages are supported by .net?

0 Answers  

What is a preprocessor directive in vb.net?

0 Answers  

Name the class which allows an element to be accessed using unique key?

0 Answers  

1.wht is satellite assembly??? 2.How Garbage Collector works can u explain ????

3 Answers   ABC,

concept of object oriented programming

6 Answers   Patni,

What is the difference b/w Readonly Variable and Constant Variable?

7 Answers   Ksb, Sonata,

IT openings for Experienced candiates for Java / .NET

1 Answers  

Can you please explain the difference between namespace and assembly?

0 Answers