dev
sql server 2000 + How to display date time
Over on Experts Exchange I saw a question that I get all the time, "How do I format this DATETIME like x?" If they're asking to learn, I point them over to the
SQL201
SQL102
SQL 201 – Contstraints
Constraints... helpful in making sure you get the data you want out of your database! Constraints allow you to define rules that the data must follow in order
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
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
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
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
t-sql
SQL 201-SELECT INTO
I've already shown you how to create a table, and how to INSERT data into that table. But did you know you can do both in one statement? The SELECT INTO
microsoft sql
SQL 201 – Locking Hints
If you've spent any time looking at another programmers code, I'm sure you've see something like this: SELECT columnName FROM tableName (NOLOCK) I'm sure you
SQL201
Optimizing Queries
This is the first article in a never ending series of articles on how to optimize your queries. Honestly, this is a topic I'm still learning volumes about. I
SQL102
SQL 201 – Statistics
Microsoft SQL Servers collect statistical information on indexes and column data stored in each database. These statistics are used by the query optimizer to
SQL201
SELECT CASE
A useful skill to learn in SQL is how to translate a value into a description. You’ll use it all the time. Whether you’re turning M|F into Male or