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
dev
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
t-sql
SQL 102 – Foreign Keys
In the simplest terms a Foreign Key in one table refers to the Primary Key of another table. Let's go back to our demo tables products and productSales. -
t-sql
Beginning SQL Server 2005 Programming
I was looking for a good reference book to use in creating training lessons for the site. I have to say this book is great for that. Lucky for me, it's not as
dev
Whistle While You Work
Well, lets see. I've been back in the coding game for more than a day now. It is so nice to be in a position to solve problems, and develop new and better ways
dev
Changes to ToyboxCreations!
I hope you all can appreciate the new face lift I've given the site. This version is built from scratch in PHP with a MySQL backend. The template is based on a
dev
My Milage Widget
After getting back from a long vacation weekend filled with plenty of driving, I started thinking. How many miles have I driven. Not just today, not just this
t-sql
Sams Teach Yourself SQL in 10 Minutes (3rd Edition)
I picked up this book to try and refine my understanding of SQL as quickly as possible. I was looking to get a quick overview, and a list of topics I could dig