Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

T-SQL SELECT..INTO Expand / Collapse
Author
Message
Posted Monday, March 10, 2014 10:09 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Comments posted to this topic are about the item T-SQL SELECT..INTO

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1549547
Posted Monday, March 10, 2014 11:30 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 7:59 PM
Points: 1,756, Visits: 765
Interesting question, thanks.

Hope this helps...

Ford Fairlane
Rock and Roll Detective





Post #1549553
Posted Tuesday, March 11, 2014 1:23 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Sunday, October 12, 2014 11:25 PM
Points: 717, Visits: 938
Nice Question...
Post #1549581
Posted Tuesday, March 11, 2014 1:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:35 AM
Points: 13,240, Visits: 11,019
Great question.
Although the IDENTITY property doesn't always transfer:


When an existing identity column is selected into a new table, the new column inherits the IDENTITY property, unless one of the following conditions is true:
*The SELECT statement contains a join, GROUP BY clause, or aggregate function.
*Multiple SELECT statements are joined by using UNION.
*The identity column is listed more than one time in the select list.
*The identity column is part of an expression.
*The identity column is from a remote data source.


INTO Clause (Transact-SQL)




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1549582
Posted Tuesday, March 11, 2014 1:59 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 3:37 AM
Points: 4,013, Visits: 5,306
Interesting question, thanks
As stated by Koen above, the answer relating to the identity column is "it depends", or "sometimes"


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1549585
Posted Tuesday, March 11, 2014 2:21 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 1:02 PM
Points: 998, Visits: 2,280
Good one. Thank you for the post.

out of three, got two right...


ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1549591
Posted Tuesday, March 11, 2014 2:54 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 8:44 AM
Points: 1,777, Visits: 6,456
Took a lot of thinking to work out all those double negatives!
Post #1549601
Posted Tuesday, March 11, 2014 3:00 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 10:06 AM
Points: 1,105, Visits: 3,541
Toreador (3/11/2014)
Took a lot of thinking to work out all those double negatives!


+1



On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help
Post #1549604
Posted Tuesday, March 11, 2014 3:20 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 6:53 AM
Points: 2,165, Visits: 1,752
Toreador (3/11/2014)
Took a lot of thinking to work out all those double negatives!


Yes, I fell down on the Filestream one because of that!
Post #1549608
Posted Tuesday, March 11, 2014 5:36 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 1:21 PM
Points: 4,202, Visits: 3,639
The identity got me.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1549671
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse