Answer / ruchi

A view is a virtual table that consists of columns from one
or more tables. Though it is similar to a table, it is
stored in the database. It is a query stored as an object.
Hence, a view is an object that derives its data from one or
more tables. These tables are referred to as base or
underlying tables.

Once you have defined a view, you can reference it like any
other table in a database.
CREATE VIEW view_name
[(column_name[,column_name]….)]
[WITH ENCRYPTION]
AS select_statement [WITH CHECK OPTION]
Where:


A stored procedure is nothing more than prepared SQL code
that you save so you can reuse the code over and over again.
So if you think about a query that you write over and over
again, instead of having to write that query each time you
would save it as a stored procedure and then just call the
stored procedure to execute the SQL code that you saved as
part of the stored procedure.

Answer / asif aslam

In views we can access data with a page,not like session b/w
the pages.
Stored Procedure use for Database communication...
For Example: add,remove,update etc any record from database.

What is namespace in ado.net?

0 Answers  

---

Command objects uses, purposes and their methods.

0 Answers  

---

How to get oledb connection?

3 Answers  

---

Describe connection object in ado.net

0 Answers  

---

What is disconnected scenario in entity framework?

0 Answers  

---

What is method to get XML and schema from Dataset?

2 Answers  

---

Give few examples of datareader that is used in different dataproviders.

0 Answers  

---

What is the difference between ado.net and oledb?

0 Answers  

---

how we can fire event in databound coulm in datagfrid withot using button?

0 Answers   Tech Mahindra,

---

make a login control??

1 Answers  

---

I want to ask u that if i add radio button in ado.net form,and how radion button data insert in SQL2005 Database...

6 Answers  

---

What are good ado.net object to replace to ado recordset object.

0 Answers  

---