Skip to content

Instantly share code, notes, and snippets.

@ArCiGo

ArCiGo/1. Example. CREATE temp TABLE.sql

Last active May 19, 2019 21:37
Show Gist options
  • Save ArCiGo/c74f87feb2153c5daa5637b84ad43ed2 to your computer and use it in GitHub Desktop.
Save ArCiGo/c74f87feb2153c5daa5637b84ad43ed2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
1. Example. CREATE temp TABLE.sql
SELECT cust.Id,
cust.FirstName,
cust.LastName,
cust.Phone
INTO #tmpCustomers
FROM Customer cust
WHERE cust.City = 'Portland' OR cust.city = 'San Francisco';
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment