ipisors (7/30/2014)
Because the documentation on IDENTITY INSERT states that you have to explicitly pass the value to insert into PK field.Not true?
Not true from the way you're reading it. REALLY easy to do when BOL decides to be vague. The explicitly passed means you must declare the ID column in the column list and not assume it to be a member (INSERT INTO tbl SELECT blah vs. INSERT INTO tbl (blah) SELECT blah).
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA