Skip to content

Instantly share code, notes, and snippets.

@choudeshell
Created September 7, 2013 06:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save choudeshell/6473344 to your computer and use it in GitHub Desktop.
Save choudeshell/6473344 to your computer and use it in GitHub Desktop.
DECLARE @a int
SET @a = 100
DECLARE @b int
SET @b = 101
select * from table where tableId in (@a,@b)
select * from table where tableId = @a
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment