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 strong name in .net assembly?

0 Answers  

---

Define manifest?

0 Answers  

---

What do you mean by serialization and deserialization?

0 Answers  

---

What is multiple form in vb?

0 Answers  

---

What do you mean by deserialization?

0 Answers  

---

---

Explain the difference between datatable and dataset?

0 Answers  

---

difference between control and component more than one differences

0 Answers  

---

how to deploy vb.net with key and evaluation time? any one can help me?

0 Answers   TSYS,

---

What is late binding and early binding?

0 Answers  

---

What is late binding?

0 Answers  

---

What are the difference between dispose(), close(), exit(), end()? When do we use them?

0 Answers  

---

What are the different types of a stream?

0 Answers  

---