I get the same error, can't find in BOL why the syntax error. Anyway, what about this: -- First add an identity column... ALTER TABLE MyTable ADD MyNewIdentityColumn INT NOT NULL IDENTITY(1,1) GO -- Next, throw the old values into the new identity column UPDATE MyTable SET MyNewIdentityColumn = MyOldIntColumn GO -- Next, drop old […]
2003-06-17
Crispin, thanks. Is there any way to return the name of each of these tables, per user? E.g., if user A created a temp table (the longer life type), how would I be able to reference it in a select statement for example? Thanks
2003-06-17
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers