Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

how to test parametrized queries?


Hello!

Is there a way or a tool where I can test queries in which I use paramteres
like

select * from tab1 t where t.f1 = :myparam1

Thx in advance,

Fritz

create table #a (Col1 int)
insert #a values (1)

declare @param int
select @param = 1

if exists (select * from #a where col1 = @param)
 select 'Exists'
  else
 select 'Doesn''t Exist'

drop table #a

"Fritz Franz" <fritzfran@hotmail.com> wrote in message

news:465e9952$0$23146$9b4e6d93@newsspool1.arcor-online.net...

"Immy" <therealasianb@hotmail.com> ha scritto

> create table #a (Col1 int)
> insert #a values (1)
> ...

Thanks, Immy for your answer - but does it belong to my question?

Regards,

Fritz

-----------------------------------------------Reply-----------------------------------------------

I thought your question was asking, "is there a way that I can test a
particular value against a variable?"
Have I misunderstood your question?

Immy

"Fritz Franz" <fritzfran@hotmail.com> wrote in message

news:465ebe71$0$6439$9b4e6d93@newsspool2.arcor-online.net...

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc