What is the difference between Stored Procedure and View?

Prakash3366 · Post by **Prakash3366** » Mon May 19, 2008 10:42 pm

Hi..
can anybody tell me , What is the difference between Stored Procedure and View?

Thanks
Prakash

ray.wurlod · Post by **ray.wurlod** » Mon May 19, 2008 10:47 pm

From a DataStage perspective, a view must be accessed via some kind of SQL-using stage, which a stored procedure must be accessed only via ODBC or Stored Procedure stages.

A view is a combination of rows and columns from one or more tables.
A stored procedure is an object in the database that can perform any action at all (not necessarily involving rows and columns), for example creating a table then creating indexes and granting permissions on it.

chulett · Post by **chulett** » Mon May 19, 2008 11:19 pm

Short answer? A view is a stored query. A stored procedure is stored code, a.k.a procedural language. Both are discrete database objects.

ag_ram · Post by **ag_ram** » Thu May 22, 2008 11:10 pm

Googling "Difference between Stored Procedure and View" could result a lot.