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 how the .net framework performs automatic memory management.

0 Answers  

Can you please explain the difference between value and reference types?

0 Answers  

What is the difference between a "jagged array" and multidimensional array" ?can anyone show me it practically ?

0 Answers  

Allowed program to auto-correct the database when loading a presentation.

0 Answers   HCL,

What is an application domain? how they get created?

0 Answers  

What’s the difference between private and shared assembly?

0 Answers  

what is delegates

2 Answers  

What are the advantages of VB.NET?

0 Answers  

Why do we use ansi keyword?

0 Answers  

what are the types of threading models in VB.net ?

1 Answers   Satyam,

What is the DIfference between Friend and Protected Friend?

6 Answers   CTS, Sykes Enterprises, TCS,

Write the role of new keyword?

0 Answers