Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2009-09-18 : 04:38:08
|
| dear userplease tell meit is posible to create view pass parameter?or how to create view within store procudure to pass parameterwhen view is exists then how alter view within sp to pass parameter thanks in advance |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-09-18 : 04:41:04
|
What do you want to do with a parameter in a view?A view is "like" a table.You can select from a view by using WHERE clause.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
amirs
Constraint Violating Yak Guru
260 Posts |
Posted - 2009-09-18 : 04:43:35
|
| ok thanks to replayhow to create view within store procudure to pass parameterwhen view is exists then how alter view within sp to pass parameter |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-09-18 : 05:10:20
|
quote:
Originally posted by amirs
ok thanks to replayhow to create view within store procudure to pass parameterwhen view is exists then how alter view within sp to pass parameter
Why do you want to do this via procedure?Can you explain what you want to do?MadhivananFailing to plan is Planning to fail |
|
|
|
amirs
Constraint Violating Yak Guru
260 Posts |
Posted - 2009-09-18 : 05:14:43
|
| i have genarete a view to matching pertcular colomnin my table there are above 100000 records whinn customer detail.i have create or alter views to perticular customer detail to pass cust name |
|
|
|
|
|
|
create view withi store procudure