In MS-SQL, how do I INSERT INTO a temp table, and have an IDENTITY field created, without first declaring the temp table?
IIRC, the INSERT INTO command uses the schema of the source table to create the temp table. That's part of the reason you can't just try to create a table with an additional column. Identity columns are internally tied to a SQL Server construct called a generator.
source
How to change identity column values programmatically?
If you need to change the IDs occasionally, it's probably best not to use an identity column. In the past we've implemented autonumber fields manually using a 'Counters' table that tracks the next ID for each table. IIRC we did this because identity columns were causing database corruption in SQL2000 but being able to change IDs was occasionally useful for testing.
source
Why do people "shrug off" the loss associated with adoption?
Well I don't know what it is like to be adopted but I know that if it turned out I was adopted, I would still love my parents the same, but I would wonder about the parents I never knew. I also would think that I would have some identity issues with being adopted like who am I, where do I come from, why did they give me up and so on but I'm not sure I would count that as loss.
source
In SQL Server 2005, can I do a cascade delete without setting the property on my tables?
My suggestion is to go ahead and write a script that will add the on delete cascade to each relationship in the database while exporting a list of modified relationships. Then you can reverse the process and remove the on delete cascade command on each table in the list.
source
How, indeed, were the identities of the hijackers known so quickly?
And, you do owe me an apology for completely misrepresenting something I said. If you think it's okay to pretend a question someone asks is actually a statement by omitting the lead-in and the question mark, you need more help than anyone can give you.
source
)