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
sql
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.
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
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
t-sql
SQL 102 — DROP DATABASE
While deleting a database is a fairly rare occurrence, I'm teaching you now, since it's a pretty easy task to learn. Before teaching you this, you do know rule
t-sql
ALTER TABLE
After you've spent time designing the perfect table, someone is going to come along and ask you a question that will lead you to changing your table. It can be