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 does assert() method do In VB.NET

0 Answers   MCN Solutions,

Explain the difference between datatable and dataset?

0 Answers  

Which namespace are used for accessing the data?

0 Answers  

Explain an assembly and its use?

0 Answers  

What is intermediate langauge?

0 Answers  

What is an application domain? how they get created?

0 Answers  

What is sorting in vb?

0 Answers  

What is the use of internal keyword?

0 Answers  

is ADO.NET important to connect sql server? is any other way to connect sql server?

1 Answers  

What is the size of .net object?

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,

Where is the Version Information Stored on a assembly ? Write the Namespace to load assemblies at runtime Can you allow a class to be inherited but prevent the method from being overridden ? What happens in memory when you box and unbox a value type ? Write a progtam to convert decimal to byte without using library function.

2 Answers   HCL,