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
t-sql
t-sql
Determine the Space Used by Tables
Eventually you'll be faced with running out of space on a SQL server. Usually, before you get more drive space, you're asked to find out if you can get rid of
t-sql
Inter-Database Queries
I've had this question come up a few times now. "How do I copy data from one database to another?" It's after getting a question like that, I explain fully
t-sql
SQL 201 — CREATE PROCEDURE
Now that you have the basics of SQL, I think it's time to learn something a bit more involved. If you need to accomplish a task within SQL you will run a series
t-sql
SQL 201 – CREATE TABLE
CREATE TABLE I've showed you how to get data out of a table, put data in, change it, and delete it. But I haven't showed you how to create your own table...
t-sql
SQL 101 – DELETE
It looks like I'm getting close to the end of my 101 series. After I show you how to remove data from tables, the last topic I plan to cover is creating tables.
microsoft sql
SQL 101 – TRANSACTION
As I mentioned in my previous post, before you move on to more difficult topics I need to share with you what a TRANSACTION is, and how to use them. By now
t-sql
SQL 101 – INSERT
In all the previous articles I've written on SQL I've showed you how to get data out of the database. Now, we're switching gears. I'm going to show you how to
t-sql
SQL 101 – UPDATE
Previously, I showed you how to get new information into a SQL database. This time I'll show you how to make changes to that data, once it's in there. The basic
microsoft sql
Comparing Query Performance
A significant portion of your time as a database programmer or administrator will be to improve the performance of queries. While there are several benchmarks
t-sql
Moving Data Between Tables
Very early into my SQL career I had to get comfortable moving records around between tables and databases. There are several ways to do it, you just have to
microsoft sql
SQL 201 – Combining Query Results
Overview There comes a point in your SQL career where you will need to combine the results of several queries into one data set, and present it in one view.