If you’re not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the SQL Server community in Charlotte, NC. Their plan is to get together once a month and discuss a new and interesting topic on SQL Server….
Month: August 2007
Exception Handling
Learning to handle errors better can be one of the skills that will really set you apart from other SQL Developers. You can do constant unit testing after each change, but odds are you’ll never hit ever scenario your code will face. There is a better way. If you have programmed in any language like…
New Sample Databases for 2005!
Back when we were all using SQL 2000, I shared a link to download SQL 2000 demo databases. Now, most of us are on SQL 2005, we need a new database to work with. Microsoft was kind enough to oblige, so here it is! The link below will let you download sample databases for your…
Default Values
When you start creating tables and setting them so they can’t have NULL values, you’ll eventually need a way to define a default value for the column. A default value is one that a column would apply to its record if a value is not provided. To specify the default value in a SQL statement,…