>Hi,
>
>I was wondering if I would be breaking some unwritten rule or good practice if I set multiple variables in one line/statement, as following:
>
>
>declare @test1 as char(20), @test2 as char(10), @test3 as varchar(30)
>select @test1 = '', @test2 = '', @test3 = ''
>
>
>TIA
No, AFAIK, but I prefer multi line.
..
SET @test1 = ''
SET @test2 = ''
SET @test3 = ''
..
That way is more visible.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.