Windows Phone 7 Developer Launch - Learn More

T-SQL

There are 1 entries for the tag T-SQL

SQL Server add column with DEFAULT CONSTRAINT: The Dumb Little Things

Sometimes you think you know and then when you go and open your big mouth and make a fool of yourself. I generally script all my database changes by hand. Not 100%, if it’s a big change I’ll right-click the object and use the script menu command to generate a script I can paste into my script editor. But often if I’m creating new objects I’ll write the script by hand from scratch. Last week I needed to add a column to three separate tables and the column was not nullable. So as I have...

 

 

Copyright © Mark J. Miller