WHAT IS DIFF B/W VIEWS AND STORED PROCEDURE

Question Posted / vikram

2 Answers
5617 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

WHAT IS DIFF B/W VIEWS AND STORED PROCEDURE..

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

WHAT IS DIFF B/W VIEWS AND 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.

Is This Answer Correct ?

3 Yes

5 No

Post New Answer

More ADO.NET Interview Questions

If i am expecting a single result from sqlserverdatabase then what command should i follow ?sqlcommand.executereader (commandbehaviour.singleresult)or sqlcommand.executescalar()

4 Answers

Execute nonquery returns no. of afected rows.So if my stored procedure hav lot of select stmnt, delete stmnt, insert stmnt..then what does execute nonquery returns in this case?

6 Answers Wipro,

what is typed and untyped dataset

3 Answers

What you mean by filtering of data?

0 Answers

what is the syntax code to oledb to connect oracle

6 Answers IBM,

What is ado.net and its architecture?

0 Answers

What are the 4 types of classes in ADO.NET?

5 Answers

When we are running the Application, if any errors occur in the Stored Procedure then how will the server identify the errors?