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 |
|
Starlet_GT
Yak Posting Veteran
81 Posts |
 Posted - 2007-09-05 : 03:05:35
|
| can i create a view with parameters? Because I want to call that view from my .NET web application and pass some parameters.Keeping in mind that this view will be created on Linked Oracle server. |
|
|
Koji Matsumura
Posting Yak Master
141 Posts |
Posted - 2007-09-05 : 03:26:00
|
| No. You can use a SP or make use of a UDF if you must use a view. |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-05 : 03:45:56
|
No.I have no idea how ORACLE do, but in SQL Server you can write a TABLE function which accepts parameters and return a resultset.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-09-05 : 06:42:29
|
| As said, create a sp with parameters which queries on viewCreate procedure your_proc(param lists...)asSelect columns from your_viewwhere .......MadhivananFailing to plan is Planning to fail |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-05 : 06:45:42
|
quote:
Originally posted by Starlet_GT
can i create a view with parameters? Because I want to call that view from my .NET web application and pass some parameters.Keeping in mind that this view will be created on Linked Oracle server.
I believe in Oracle it is possible, but not in SQL Server.
Future guru in the making. |
|
|
|
|
|
|
Views with Parameters