Re: general question

http://ryanfarley.com/blog/archive/2004/03/01/390.aspx

On Jul 26, 1:59 pm, "MikeJ" <vettes_n_j...@xxxxxxxxxxxxx> wrote:
hi...i would like to know best practice when assigning a value to a variable
example below

set
or
select

declare @var1 varchar(25)
set @var1='abc'
select @var1='abc'

to me
set is implicit
select implies conditions

i see both used all over the place here at my new company....
so witch is better practice

tks
MJ


.

Relevant Pages

  • Disregard
    ... declare @var1 varchar ... set is implicit ... select implies conditions ...
    (microsoft.public.windows.server.general)
  • Re: FOR070.DAT files appearing
    ... > in the header then they couldn't be picked up. ... Nothing should be left to implicit. ... since Fortran has required. ... Declare before use. ...
    (comp.os.vms)
  • Re: Is cast operator unary or binary? How many operands?
    ... using implicit int AND implicit extern. ... distinguishable from other identifiers by context. ... declare f as function taking one argument of type int, ... If one attempts to use a conventional scanner and parser generator ...
    (comp.lang.c)
  • Re: Main program, function, module - it does not work.
    ... > Do one need inside of a function declare variable which corresponds to ... The rules about implicit typing are consistent and apply to ... declaration of it (in the interface body). ... how is the compiler supposed to "know" the ...
    (comp.lang.fortran)
  • Re: Floating point crash due to implicit
    ... > IMPLICIT DOUBLE PRECISION ... just have to declare the appropriate type in both places. ... > explain to my what happened here on a compiler level and why the compiler ...
    (comp.lang.fortran)