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 MSIL.

8 Answers   HDFC,

What would you do to remove microsoft visual basic name space?

0 Answers  

Write a program that would find the nth term of a geometric progression, given the value of first term and common ratio. Any inbuilt function that the language provides for calculating exponent should not be used.

0 Answers  

Why should you use delegate?

0 Answers  

How to create Crystal Report in vb.net with coding

1 Answers   A3Logics, Ascent, TCS,

Write a VB.Net console program to check whether a number is perfect or not.

1 Answers   Wipro,

Explain private assembly?

0 Answers  

How to connect a service based database to vb.net forms? Do we have to create any specific database?

1 Answers  

Explain option explicit?

0 Answers  

Explain the use of serialization and deserialization?

0 Answers  

wht is the use of console application?

3 Answers   MRB,

if user enters 1 or 2 or any other number in digit format in next textbox it should show the answer in word reading like if enters 12 answer should be twelve

4 Answers