April 3, 2023 at 12:00 am
Comments posted to this topic are about the item Adding Multiple Columns
April 3, 2023 at 1:14 am
Nice question, Steve!
--Jeff Moden
Change is inevitable... Change for the better is not.
April 3, 2023 at 1:53 pm
Thanks, ran into someone that didn't know you could do this in one statement.
April 3, 2023 at 2:17 pm
But you should add the NULLability setting to the column. The default is somewhat obscure so you should always specify NULL or NOT NULL when adding a column.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
April 3, 2023 at 2:42 pm
Thanks, ran into someone that didn't know you could do this in one statement.
That's the main reason I really liked the question. I've run into a whole lot of folks by way of code reviews that don't know this.
There's another nuance about adding columns. I'll see if I'm remembering it correctly and, maybe, submit a question on it.
And, thanks for what you do, Steve.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy