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 significance of delegates. Where should they be used? What are the situations where we require them?

0 Answers  

Regarding Types of compatability in VB and their usage ?

1 Answers   Satyam,

What is late binding?

0 Answers  

I want to sample Hotel management project in vb.net because still now i am doing that project for small hotel....so please send me my email id is jmuthu_pearls@yahoo.com...

4 Answers   Sapphire Comfort Hotel, TATA,

i have attended interview for cognizant ( 3 +,on .net ) on 19-06-2010 till now i have not given the status ..am confused... does any one faced same situation ...could please tell what would be happened

1 Answers  

What is the use of console application?

0 Answers  

What is tracing?

0 Answers  

How do you retrieve the customized properties of a .net application from xml .config file?

0 Answers  

What are the differences between server-side and client-side code?

0 Answers  

What is the significance of delegates. Where should they be used?

0 Answers  

when we will use console ?

3 Answers  

Explain the difference between .dll extension and .exe extension files?

0 Answers