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
...
> 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
"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
...
> "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
Add to del.icio.us |
Digg this |
Stumble it |
Powered by Megasolutions Inc
