[dba-SQLServer] SELECT INTO Versus CREATE #temp

> One other completely unrelated question: why is it that your messages (and
> only yours) have about 100 blank lines between the end of the message and
> the usual dba-SQL Server mailing list signature?

No idea, but now I notice that all mails I receive has these blank lines.
Maybe it's my Outlook, maybe it's my CA Anti-spam.
Anyway, the lines certainly add up, and I'll remember to delete them from my
postings in the future. Please tell me if this mail still contains blank
lines.

Thanks,
Asger

-----Oprindelig meddelelse-----
Fra: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af Arthur
Fuller
Sendt: 18. juli 2008 16:06
Til: Discussion concerning MS SQL Server
Emne: Re: [dba-SQLServer] SELECT INTO Versus CREATE #temp

I guess maybe I can only find out by writing a test case that inserts 1K or
10k rows. None of the instances of such code impose any constraints, so it
may be 6 of one and 1/2 dozen of the other. Maybe they both resolve to
identical code beneath the covers; maybe not. I'll write my test case and
report back with the results.

One other completely unrelated question: why is it that your messages (and
only yours) have about 100 blank lines between the end of the message and
the usual dba-SQL Server mailing list signature?

Thanks,
Arthur

On Fri, Jul 18, 2008 at 10:54 AM, Asger Blond <ab-mi at post3.tele.dk> wrote:

> With CREATE TABLE #tempTable you can specify constraints (and thereby
> unique
> indexes if you specify a primary key or unique constraint) in the
> create-table-statement.
>
> A table created with SELECT INTO doesn't inherit any constraints or
indexes
> from the source table. But you can of course build these constraints and
> indexes on the destination table after it has been created.
>
> No other difference as far as I know.
>
> Asger
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com