Skip to content

Instantly share code, notes, and snippets.

@FilipDeVos

FilipDeVos/collation_safe_temptables_08.sql

Created May 13, 2011 08:13
Show Gist options
  • Save FilipDeVos/970187 to your computer and use it in GitHub Desktop.
Save FilipDeVos/970187 to your computer and use it in GitHub Desktop.
Download ZIP
Create Collation safe TempTables
Raw
collation_safe_temptables_08.sql
SELECT 'tempdb' as db, TABLE_NAME, COLUMN_NAME, COLLATION_NAME
FROM tempdb.INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME like '#RockStarInfo3%'
AND TABLE_SCHEMA = current_user
AND COLUMN_NAME = 'name'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment