Re: optional parameter in sql query

Hi

I want to use the td column in the query only if @td variable is
passed to the stored procedure.

Thannks

.

Relevant Pages

  • Q: on stored procedure
    ... In a stored procedure I've a WHERE condition which asks for the following ... When I run the query, the window comes up with D_END and then with D_Start. ... Prev by Date: ...
    (microsoft.public.sqlserver.datamining)
  • Re: What is the "@" for?
    ... where you got that query from? ... I bet it was from a stored procedure, if that is so you cannot use it from ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
  • Help with Stored Procedure Execution Speed - Delphi 6
    ... I call the stored procedure using a TADOQuery passing the ... query because I think I read somewhere that that should help. ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • DataSet.WriteXml
    ... I have a stored procedure with a query ... I need my xml looks like this ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Stored Procedure - Obtaining Output
    ... I would like to set up a stored procedure that does the following... ... How to I trap the output of this query! ... Wez ... Prev by Date: ...
    (microsoft.public.sqlserver.mseq)