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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calling a Stored procedure from a View

Status
Not open for further replies.
camy123

camy123

Programmer
Mar 5, 2004
171
GB
guys how do i call a stored procedure from a view

thanx

 
Sort by date Sort by votes
You can't, but a SP can call a view.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]
 
Upvote 0 Downvote
Not even dynamically.

A stored procedure is usually more efficient than a view and has the advantagethat you can call it using parameters. Just write a stored procedure to do the whole taks you want done.

Questions about posting. See faq183-874
 
Upvote 0 Downvote
Ahh, there are limits to the misuse of dynamic SQL.[spin2]
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
901
SashaBuilder3
SashaBuilder3
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
613
Chris Miller
Chris Miller
bharons
  • Locked
  • Question
Pick up value from combobox
Replies
0
Views
607
bharons
bharons
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
704
Mike Lewis
Mike Lewis
Cpreston
  • Locked
  • Question
How to add a Letter to datepart
Replies
5
Views
803
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top