How to set multiple local variables in one line using T-SQL?

Question

declare @inserted bit
declare @removed bit

I know it's possible to set them like below:

SELECT @inserted = 0, @removed = 0

but would it be possible to make this even simpler and use something like:

SET @inserted, @removed = 0

Many thanks

marc_s · Accepted Answer · 2011-11-25 12:31:40Z

27

How about:

declare @inserted BIT = 0, @removed BIT = 0

Works in SQL Server 2008 and up (you didn't specify which version of SQL Server....)

Update: ok, so you're stuck on SQL Server 2005 - in that case, I believe this is the best you can do:

DECLARE @inserted BIT, @removed BIT
SELECT @inserted = 0, @removed = 0

answered Nov 25, 2011 at 12:23

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

but would it be possible to make this even simpler and use something like:
SET @inserted, @removed = 0

I suppose yo mean

SET @inserted = @removed = 0

No, that is not possible. T-SQL does not support this kind of syntax.

CommunityBot

11 silver badge

answered Nov 25, 2011 at 12:24

Tomalak

340k68 gold badges547 silver badges635 bronze badges