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.
microsoft sql
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
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
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
SQL102
DROP and Truncate
It's only a matter of time before you need to clean up after yourself in Microsoft SQL. You'll have to get rid of an index, or a table, or maybe even a whole
SQL102
SQL 102 — CREATE DATABASE
The most fundamental task you'll have to learn to do as a Database Administrator is to create a database. Please remember it's probably a good idea to make
microsoft sql
Alias
Within a few days of using SQL, you're going to start wondering if there is a way to speed up your code writing. The good news is you can do that with Aliases.