"martin" <anonymous@discussions.microsoft.com> wrote in message
news:1f8e01c3af08$08e57340$a601280a@phx.gbl...
> hi all
>
> I'd like to know the differences between
>
> set @var=var
> select @var=var
>
> They are used to assign the var to @var. but is any
> difference in order to use the cache? I assume there is
> no difference because I dont change any table, so the sp
> is recovered from the cache either way. is it right?
>
> then, is it nevertheless which way I use?
>
> many thanks

"Raman Iyer [MS]" <ramaniy@online.microsoft.com> wrote in message
news:#TFSd35rDHA.3536@tk2msftngp13.phx.gbl...
> Forwarding to a more appropriate newsgroup.
>
>
> "martin" <anonymous@discussions.microsoft.com> wrote in message
> news:1f8e01c3af08$08e57340$a601280a@phx.gbl...
> > hi all
> >
> > I'd like to know the differences between
> >
> > set @var=var
> > select @var=var
> >
> > They are used to assign the var to @var. but is any
> > difference in order to use the cache? I assume there is
> > no difference because I dont change any table, so the sp
> > is recovered from the cache either way. is it right?
> >
> > then, is it nevertheless which way I use?
> >
> > many thanks
>
>