Guest User

Untitled

a guest
Oct 16th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. SELECT [id],[fullname] FROM persons WHERE [id] IN (5802824683954111059,1615647673927737)
  2.  
  3. IF OBJECT_ID('tempdb..#temp_table_1') IS NOT NULL
  4. TRUNCATE TABLE #temp_table_1
  5. ELSE
  6. CREATE TABLE #temp_table_1 ( [key] bigint primary key );
  7. INSERT INTO #temp_table_1 ([key]) VALUES (5802824683954111059),(1615647673927737);
  8. SELECT [id],[fullname] FROM persons WHERE [id] IN (SELECT [key] FROM #temp_table_1)
Add Comment
Please, Sign In to add comment