Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT IS DIFF B/W VIEWS AND STORED PROCEDURE
- 2 Answers
- 5720 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 9 Yes | 0 No |
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.
| Is This Answer Correct ? | 3 Yes | 5 No |
What are the advantages of oledb compared with other classes?
What is the full form of ado?
What are the advantages of using datalist?
ADO and ADO.NET differences?
What happens when u try to update data in a dataset in .NET while the record is already deleted in SQL SERVER as backend?
What are the different methods by which we can populate a dataset?
Explain the role of data provider in ado.net?
What is the difference between an ADO.NET Dataset and an ADO Recordset?
What is the functionality of data provider in ado.net?
How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
Diff. b/w DataReader and DataSet?
What is DataReader Object?
-
Visual Basic (800) - C Sharp (3816)
- ASP.NET (3180)
- VB.NET (461)
- COM+ (79)
- ADO.NET (717)
- IIS (369)
- MTS (11)
- Crystal Reports (81)
- BizTalk (89)
- Dot Net (2435)
- Exchange Server (362)
- SharePoint (720)
- WCF (340)
- MS Office Microsoft (6963)
- LINQ Language-Integrated Query (317)
- WPF (371)
- TypeScript (144)
- Microsoft Related AllOther (311)
