creating view as a parameter query

Hi,
I created a view in EM and when i right-click to go to the query designer
it allows me to set some parameter but i seem not able to save this as part
of a view ?
how can i do that or is there other alternatives ?
tks & rdgs
You can create a table function to simulate a parameterized view. See "create
function" in BOL.
AMB
"maxzsim" wrote:

> Hi,
> I created a view in EM and when i right-click to go to the query designer
> it allows me to set some parameter but i seem not able to save this as part
> of a view ?
> how can i do that or is there other alternatives ?
> tks & rdgs

creating view as a parameter query

Hi,
I created a view in EM and when i right-click to go to the query designer
it allows me to set some parameter but i seem not able to save this as part
of a view ?
how can i do that or is there other alternatives ?
tks & rdgsYou can create a table function to simulate a parameterized view. See "creat
e
function" in BOL.
AMB
"maxzsim" wrote:

> Hi,
> I created a view in EM and when i right-click to go to the query designer
> it allows me to set some parameter but i seem not able to save this as par
t
> of a view ?
> how can i do that or is there other alternatives ?
> tks & rdgs

creating view as a parameter query

Hi,
I created a view in EM and when i right-click to go to the query designer
it allows me to set some parameter but i seem not able to save this as part
of a view ?
how can i do that or is there other alternatives ?
tks & rdgsYou can create a table function to simulate a parameterized view. See "create
function" in BOL.
AMB
"maxzsim" wrote:
> Hi,
> I created a view in EM and when i right-click to go to the query designer
> it allows me to set some parameter but i seem not able to save this as part
> of a view ?
> how can i do that or is there other alternatives ?
> tks & rdgssql

creating server alias without Client Tools installed?

Hi All: What is the MDAC application that allows you to create server
aliases if you don't have Client Tools installed?
sorry...I was looking for "cliconfg.exe"
"geek-y-guy" <noone@.nowhere.com> wrote in message
news:eQFUPOCHGHA.1628@.TK2MSFTNGP12.phx.gbl...
> Hi All: What is the MDAC application that allows you to create server
> aliases if you don't have Client Tools installed?
>