Skip to content

Instantly share code, notes, and snippets.

@FilipDeVos

FilipDeVos/collation_safe_temptables_05.sql

Created May 13, 2011 07:58
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save FilipDeVos/970171 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save FilipDeVos/970171 to your computer and use it in GitHub Desktop.
Download ZIP
Create Collation safe TempTables
Raw
collation_safe_temptables_05.sql
SELECT db_name() as db, TABLE_NAME, COLUMN_NAME, COLLATION_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'RockStars'
AND TABLE_SCHEMA = current_user
AND COLUMN_NAME = 'name'
SELECT 'tempdb' as db, TABLE_NAME, COLUMN_NAME, COLLATION_NAME
FROM tempdb.INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME like '#RockStarInfo%'
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