Why is it that I can create a parameter query in Enterprise Manager but
cannot repeat this in query analyser? How could I create a run time parameter
query (in my parlance a query that allows users to input values)!?
Thanks
SamOn Tue, 18 Jan 2005 03:29:03 -0800, Sam wrote:
>Why is it that I can create a parameter query in Enterprise Manager but
>cannot repeat this in query analyser? How could I create a run time parameter
>query (in my parlance a query that allows users to input values)!?
>Thanks
>Sam
Hi Sam,
This can't be done. Interaction with the end user (like asking for a
parameter) must be handled by the client application.
EM apparently has some support for asking parameter values. QA doesn't.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||SQL Server is a back-end server. It cannot ask a user for any parameters since SQL Server runs only
on the server. Possibly EM has some facility to ask for a parameter value, but that would be a
feature in EM. In SQL Server, you typically use stored procedures, where a stored procedure can take
a number of parameters, where the parameters are used inside the query or queries inside the
procedure.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:3755656C-5C1E-4AB5-9018-68B80F3FA855@.microsoft.com...
> Why is it that I can create a parameter query in Enterprise Manager but
> cannot repeat this in query analyser? How could I create a run time parameter
> query (in my parlance a query that allows users to input values)!?
> Thanks
> Sam
>sql
Showing posts with label analyser. Show all posts
Showing posts with label analyser. Show all posts
Wednesday, March 21, 2012
Run Time parameter query
Why is it that I can create a parameter query in Enterprise Manager but
cannot repeat this in query analyser? How could I create a run time parameter
query (in my parlance a query that allows users to input values)!?
Thanks
Sam
On Tue, 18 Jan 2005 03:29:03 -0800, Sam wrote:
>Why is it that I can create a parameter query in Enterprise Manager but
>cannot repeat this in query analyser? How could I create a run time parameter
>query (in my parlance a query that allows users to input values)!?
>Thanks
>Sam
Hi Sam,
This can't be done. Interaction with the end user (like asking for a
parameter) must be handled by the client application.
EM apparently has some support for asking parameter values. QA doesn't.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||SQL Server is a back-end server. It cannot ask a user for any parameters since SQL Server runs only
on the server. Possibly EM has some facility to ask for a parameter value, but that would be a
feature in EM. In SQL Server, you typically use stored procedures, where a stored procedure can take
a number of parameters, where the parameters are used inside the query or queries inside the
procedure.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:3755656C-5C1E-4AB5-9018-68B80F3FA855@.microsoft.com...
> Why is it that I can create a parameter query in Enterprise Manager but
> cannot repeat this in query analyser? How could I create a run time parameter
> query (in my parlance a query that allows users to input values)!?
> Thanks
> Sam
>
cannot repeat this in query analyser? How could I create a run time parameter
query (in my parlance a query that allows users to input values)!?
Thanks
Sam
On Tue, 18 Jan 2005 03:29:03 -0800, Sam wrote:
>Why is it that I can create a parameter query in Enterprise Manager but
>cannot repeat this in query analyser? How could I create a run time parameter
>query (in my parlance a query that allows users to input values)!?
>Thanks
>Sam
Hi Sam,
This can't be done. Interaction with the end user (like asking for a
parameter) must be handled by the client application.
EM apparently has some support for asking parameter values. QA doesn't.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||SQL Server is a back-end server. It cannot ask a user for any parameters since SQL Server runs only
on the server. Possibly EM has some facility to ask for a parameter value, but that would be a
feature in EM. In SQL Server, you typically use stored procedures, where a stored procedure can take
a number of parameters, where the parameters are used inside the query or queries inside the
procedure.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:3755656C-5C1E-4AB5-9018-68B80F3FA855@.microsoft.com...
> Why is it that I can create a parameter query in Enterprise Manager but
> cannot repeat this in query analyser? How could I create a run time parameter
> query (in my parlance a query that allows users to input values)!?
> Thanks
> Sam
>
Run Time parameter query
Why is it that I can create a parameter query in Enterprise Manager but
cannot repeat this in query analyser? How could I create a run time paramete
r
query (in my parlance a query that allows users to input values)!?
Thanks
SamOn Tue, 18 Jan 2005 03:29:03 -0800, Sam wrote:
>Why is it that I can create a parameter query in Enterprise Manager but
>cannot repeat this in query analyser? How could I create a run time paramet
er
>query (in my parlance a query that allows users to input values)!?
>Thanks
>Sam
Hi Sam,
This can't be done. Interaction with the end user (like asking for a
parameter) must be handled by the client application.
EM apparently has some support for asking parameter values. QA doesn't.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||SQL Server is a back-end server. It cannot ask a user for any parameters sin
ce SQL Server runs only
on the server. Possibly EM has some facility to ask for a parameter value, b
ut that would be a
feature in EM. In SQL Server, you typically use stored procedures, where a s
tored procedure can take
a number of parameters, where the parameters are used inside the query or qu
eries inside the
procedure.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:3755656C-5C1E-4AB5-9018-68B80F3FA855@.microsoft.com...
> Why is it that I can create a parameter query in Enterprise Manager but
> cannot repeat this in query analyser? How could I create a run time parame
ter
> query (in my parlance a query that allows users to input values)!?
> Thanks
> Sam
>
cannot repeat this in query analyser? How could I create a run time paramete
r
query (in my parlance a query that allows users to input values)!?
Thanks
SamOn Tue, 18 Jan 2005 03:29:03 -0800, Sam wrote:
>Why is it that I can create a parameter query in Enterprise Manager but
>cannot repeat this in query analyser? How could I create a run time paramet
er
>query (in my parlance a query that allows users to input values)!?
>Thanks
>Sam
Hi Sam,
This can't be done. Interaction with the end user (like asking for a
parameter) must be handled by the client application.
EM apparently has some support for asking parameter values. QA doesn't.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||SQL Server is a back-end server. It cannot ask a user for any parameters sin
ce SQL Server runs only
on the server. Possibly EM has some facility to ask for a parameter value, b
ut that would be a
feature in EM. In SQL Server, you typically use stored procedures, where a s
tored procedure can take
a number of parameters, where the parameters are used inside the query or qu
eries inside the
procedure.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:3755656C-5C1E-4AB5-9018-68B80F3FA855@.microsoft.com...
> Why is it that I can create a parameter query in Enterprise Manager but
> cannot repeat this in query analyser? How could I create a run time parame
ter
> query (in my parlance a query that allows users to input values)!?
> Thanks
> Sam
>
Tuesday, March 20, 2012
Run query without sql server (2000)
Hi all,
I wrote a query in SQL server query analyser and would like a user to run th
is regularly. However it’s not possible to give them SQL server. Can they
do this another way i.e. through Access or similar?
Many thanks
IGYou could just install sql server client utilities (without the server).
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Igloo" <anonymous@.discussions.microsoft.com> wrote in message
news:218EDD05-8623-4B1C-9835-4A3CB384C7CE@.microsoft.com...
Hi all,
I wrote a query in SQL server query analyser and would like a user to run
this regularly. However it's not possible to give them SQL server. Can they
do this another way i.e. through Access or similar?
Many thanks
IG|||You must install the SQL client connectivity piece for them to use SQL OR
Create some middle tier object with access and let them use the middle tier
object
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Igloo" <anonymous@.discussions.microsoft.com> wrote in message
news:218EDD05-8623-4B1C-9835-4A3CB384C7CE@.microsoft.com...
this regularly. However it's not possible to give them SQL server. Can they
do this another way i.e. through Access or similar?
ur SQL database, create your query as a view on your SQL box, then use Acces
s to link the view as a table/data source. I do it all the time for user re
porting. It provides data
integrity because you can make the view read-only so users can't change the
data, and the users can only see what you let them, so you have data securit
y.
It's also a good way to make ad hoc query tools when you want to provide the
intelligence so that the users don't have to learn SQL.
I wrote a query in SQL server query analyser and would like a user to run th
is regularly. However it’s not possible to give them SQL server. Can they
do this another way i.e. through Access or similar?
Many thanks
IGYou could just install sql server client utilities (without the server).
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Igloo" <anonymous@.discussions.microsoft.com> wrote in message
news:218EDD05-8623-4B1C-9835-4A3CB384C7CE@.microsoft.com...
Hi all,
I wrote a query in SQL server query analyser and would like a user to run
this regularly. However it's not possible to give them SQL server. Can they
do this another way i.e. through Access or similar?
Many thanks
IG|||You must install the SQL client connectivity piece for them to use SQL OR
Create some middle tier object with access and let them use the middle tier
object
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Igloo" <anonymous@.discussions.microsoft.com> wrote in message
news:218EDD05-8623-4B1C-9835-4A3CB384C7CE@.microsoft.com...
quote:
> Hi all,
> I wrote a query in SQL server query analyser and would like a user to run
this regularly. However it's not possible to give them SQL server. Can they
do this another way i.e. through Access or similar?
quote:|||You can install ODBC on the client, create a data source pointing back to yo
> Many thanks
> IG
>
ur SQL database, create your query as a view on your SQL box, then use Acces
s to link the view as a table/data source. I do it all the time for user re
porting. It provides data
integrity because you can make the view read-only so users can't change the
data, and the users can only see what you let them, so you have data securit
y.
It's also a good way to make ad hoc query tools when you want to provide the
intelligence so that the users don't have to learn SQL.
Monday, March 12, 2012
Run query without sql server (2000)
Hi all,
I wrote a query in SQL server query analyser and would like a user to run this regularly. However itâ's not possible to give them SQL server. Can they do this another way i.e. through Access or similar?
Many thanks
IGYou could just install sql server client utilities (without the server).
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Igloo" <anonymous@.discussions.microsoft.com> wrote in message
news:218EDD05-8623-4B1C-9835-4A3CB384C7CE@.microsoft.com...
Hi all,
I wrote a query in SQL server query analyser and would like a user to run
this regularly. However it's not possible to give them SQL server. Can they
do this another way i.e. through Access or similar?
Many thanks
IG|||You must install the SQL client connectivity piece for them to use SQL OR
Create some middle tier object with access and let them use the middle tier
object
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Igloo" <anonymous@.discussions.microsoft.com> wrote in message
news:218EDD05-8623-4B1C-9835-4A3CB384C7CE@.microsoft.com...
> Hi all,
> I wrote a query in SQL server query analyser and would like a user to run
this regularly. However it's not possible to give them SQL server. Can they
do this another way i.e. through Access or similar?
> Many thanks
> IG
>|||You can install ODBC on the client, create a data source pointing back to your SQL database, create your query as a view on your SQL box, then use Access to link the view as a table/data source. I do it all the time for user reporting. It provides data integrity because you can make the view read-only so users can't change the data, and the users can only see what you let them, so you have data security.
It's also a good way to make ad hoc query tools when you want to provide the intelligence so that the users don't have to learn SQL.
I wrote a query in SQL server query analyser and would like a user to run this regularly. However itâ's not possible to give them SQL server. Can they do this another way i.e. through Access or similar?
Many thanks
IGYou could just install sql server client utilities (without the server).
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Igloo" <anonymous@.discussions.microsoft.com> wrote in message
news:218EDD05-8623-4B1C-9835-4A3CB384C7CE@.microsoft.com...
Hi all,
I wrote a query in SQL server query analyser and would like a user to run
this regularly. However it's not possible to give them SQL server. Can they
do this another way i.e. through Access or similar?
Many thanks
IG|||You must install the SQL client connectivity piece for them to use SQL OR
Create some middle tier object with access and let them use the middle tier
object
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Igloo" <anonymous@.discussions.microsoft.com> wrote in message
news:218EDD05-8623-4B1C-9835-4A3CB384C7CE@.microsoft.com...
> Hi all,
> I wrote a query in SQL server query analyser and would like a user to run
this regularly. However it's not possible to give them SQL server. Can they
do this another way i.e. through Access or similar?
> Many thanks
> IG
>|||You can install ODBC on the client, create a data source pointing back to your SQL database, create your query as a view on your SQL box, then use Access to link the view as a table/data source. I do it all the time for user reporting. It provides data integrity because you can make the view read-only so users can't change the data, and the users can only see what you let them, so you have data security.
It's also a good way to make ad hoc query tools when you want to provide the intelligence so that the users don't have to learn SQL.
run multiple file .sql in Analyser
Who can i run multiple file .sql in SQL Analyser
something like this:
ecec c:\test\file1.sql
ecec c:\test\file2.sql
ecec c:\test\file3.sql
thanks
Franky
franky@.boucheros.comI think you want to look at the osql utility. It is the command-line version of Query analyzer. there is more documentation for osql in SQL BOL.
HTH
Hugh Scott|||thanks!
something like this:
ecec c:\test\file1.sql
ecec c:\test\file2.sql
ecec c:\test\file3.sql
thanks
Franky
franky@.boucheros.comI think you want to look at the osql utility. It is the command-line version of Query analyzer. there is more documentation for osql in SQL BOL.
HTH
Hugh Scott|||thanks!
Subscribe to:
Posts (Atom)