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
t-sql
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
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
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
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
SQL 102 – Users
Before you got started working with SQL Server, someone had to set up a user account for you. Now that you're learning to become a database administrator you
t-sql
SQL 201 – Views
Previously I showed you how to create tables. The normal goal for designing a table is to store data in such a way that each table contains one group of facts
t-sql
SQL 201 — User Defined Functions
Back in SQL 101, I introduced you to some functions, GETDATE(), ISNULL(string1, string2), etc. All of these functions come defined in Microsoft SQL before you
t-sql
TOP PERCENT
We have a multi-threaded process that grabs it's fair share records and then processes them. It basically looks at the total number of records to process, and