t-sql
Triggers
Triggers are one of the most misunderstood features in Microsoft SQL server. Most of that misunderstanding comes from people implementing triggers with little
Latest
t-sql
SQL Session – What’s new in Katmai (SQL Server 2008)
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
examples
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
sql
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.
dev
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
sql
SQL Session – How to Hire a DBA
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
microsoft sql
Identity Columns
An IDENTITY column is a column that automatically gets it's value set by the database engine when a new record is added. This is one of the oldest ways
t-sql
Computed Columns
What is a Computed Column A computed column is a column that users will not enter data for, but the SQL Server will compute and store a value in. The expression
Posted in: Microsoft SQL
Schema
In previous versions of SQL Server we had what we called "owners" of objects. Nearly every time you talked about an object "owner" you were talking about dbo.
microsoft sql
NULL Values, Blank Values, and Table Design
Have you dealt with NULL yet? A field is referred to as NULL if it has not received a value. To specify the NULL-ability of a column using T-SQL, just add
microsoft sql
Rename a Table or Column
In a previous post, I showed you how to rename a database in Microsoft SQL. If you haven't already been hit with a request to change the name of a table or
SQL102
Renaming a Database
A topic that you'll need sooner or later is how to rename a database. You'll get a request to build a database, and it'll be documented fairly well. You'll be