Tags: analyser, butcannot, create, database, enterprise, manager, microsoft, mysql, oracle, parameter, query, repeat, run, server, sql, time

Run Time parameter query

On Database » Microsoft SQL Server

2,097 words with 2 Comments; publish: Sun, 01 Jun 2008 15:36:00 GMT; (25062.50, « »)

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

All Comments

Leave a comment...

  • 2 Comments
    • 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)

      #1; Sun, 01 Jun 2008 15:37:00 GMT
    • 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.sqlserver.todaysummary.com.discussions.microsoft.com> wrote in message

      news:3755656C-5C1E-4AB5-9018-68B80F3FA855.sqlserver.todaysummary.com.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

      >

      #2; Sun, 01 Jun 2008 15:38:00 GMT