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 |
|
sameerv
Starting Member
29 Posts |
 Posted - 2002-10-21 : 06:18:17
|
| Hi Guys,Is there any way by which I can pass a parameter to a view at run time.i.e. Does SQL 7 support parameterized views and if so how do we do the same. |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-10-21 : 07:45:25
|
| Pretty much NO and NO ...You probably need a stored procedure that returns a single rowset ...Jay White{0} |
 |
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2002-10-22 : 21:59:05
|
| Why would you want a parameterized view? From a directly-connecting tool such as Query Analyzer you can always say SELECT * FROM view WHERE Yourfield = Yourcriteria, OTOH, if you are using ADO, you can parameterize views the same you would tables, by using a ? in the commandtext or rs.source.Sarah Berger MCSD |
|
|
|
|
|
|
Question on Views