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 top .net class that everything is derived from?

0 Answers  

What is the Difference between Web User Control and Web Custom Control?

6 Answers   Benchmark,

What is meant by jagged arrays?

0 Answers  

What is the main purpose of garbage collector?

0 Answers  

What are the features of c# which are not present in vb.net?

0 Answers  

Which properties are used to bind a DataGridView control?

0 Answers  

difference between control and component more than one differences

0 Answers  

List the types of generations in garbage collector?

0 Answers  

How vb implements the disconnected architecture as like vb.net?

0 Answers  

What is DLL HELL in VB.NET

0 Answers   HCL,

Hi I am planning to take interview in VB.net,can any one share your interview Questions for a Entry-level job. Regards Lina

3 Answers  

Thank you for replying to my Question regarding Barcodes in VB.net. My next question is that how to use Barcode Fonts in VB.net I need a small code to Generate Barcodes in VB.net from a string of Values. This is the only problem i am left with in my project. Any body can help me please.

0 Answers