Just Learned - Temporary table names and preceding #s

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Just Learned

A collection of quick technology learning tips from what people around you learn every day


	Submit a tip


	Subscribe..

Home · Most Liked · Most Learned · Most Discussed · Silver Rated · Sections

Temporary table names and preceding #s

Jun 21 2011 4:39AM by Madhivanan

Did you know that the following will work?

select * into #t from (select 1 as number) as t
select * into ###t from (select 1 as #) as t
select * into #####t from (select 1 as ###) as t
select * into ################ from (select 1 as ###) as t

Read More.. [32134 clicks]

Published under: SQL Server Tips · · · ·

Previous: variable names can be only special characters
Next: Compress files as a ZIP with COMPRESS utility in SQL Server

Madhivanan

3 · 39% · 12419

Liked

Knew

Learned

Incorrect

Interesting

Forgotten


Post this to my facebook wall
Tweet this
Like This
I knew this before
Thanks, I just learned it from you
Sorry, but this is not correct
Interesting, but not my area
I knew it but i have forgotten it


	Submit

Your Comment

Sign Up or Login to post a comment.

"Temporary table names and preceding #s" rated 5 out of 5 by 4 readers +Madhivanan

Temporary table names and preceding #s

Your Comment