Share via

Would you call this a hack...?

  • Article

Look at this piece of code...

Select *
into #Constant
from SCM3DConstant
WHERE 0=1

Would you call this piece of code a hack...? Think about the intent of this piece of code and leave comments...

Comments

  • Anonymous
    December 27, 2007
    Hi how r  u jljf asdfjasdfj asdflja sdfjad;sfj awefj;asdf a;sdjf asdfjasdf jasdflkj

  • Anonymous
    December 28, 2007
    The comment has been removed

  • Anonymous
    December 28, 2007
    The comment has been removed

  • Anonymous
    December 28, 2007
    That's an interesting way of commenting out a select statement... :P

  • Anonymous
    December 28, 2007
    The comment has been removed

  • Anonymous
    December 28, 2007
    At first glance it looks like you want to easily copy the schema of SCM3DConstant. Also, the WHERE 1=0 reminds me of old ADO code to do table insertions, ah the yesteryears.

  • Anonymous
    December 28, 2007
    This is a way to quickly create an empty temp table with the same schema as the target table.

  • Anonymous
    December 28, 2007
    I believe the intent is to build a temporary table,#Constant, with the same structure as table SCM3DConstant containing zero rows.

  • Anonymous
    December 28, 2007
    The comment has been removed

  • Anonymous
    January 03, 2008
    The comment has been removed