Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

view creation/stored procedure

Status
Not open for further replies.
Naoise

Naoise

Programmer
Dec 23, 2004
318
IE
Is it possible to create a view based on results returned from a stored procedure?

So like

CREATE VIEW myview AS EXEC mystoredprocedure
 
Sort by date Sort by votes
Depends on what database you are using.

Most dbms products have their own versions of stored procedures. Mimer, DB2 and a few others are ANSI/ISO SQL compliant.

I'm not quite sure, but I do not think ANSI SQL allows what you are asking for.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Davest11
  • Locked
  • Question
Table or View does not exist
Replies
11
Views
275
PHV
PHV
Wallie12
  • Locked
  • Question
Execution os Stored Procedure when Tables is allocated
Replies
1
Views
84
JarlH
JarlH
sinCity99
  • Locked
  • Question
Stored Procedure to insert into another table
Replies
2
Views
108
sinCity99
sinCity99
paraglidersd
  • Locked
  • Question
temp table in stored procedure
Replies
4
Views
109
paraglidersd
paraglidersd
akv003
  • Locked
  • Question
SQL Query for condition stored as column in table
Replies
5
Views
88
simian101
simian101

Part and Inventory Search

Sponsor

Back
Top