MSSQL Tutorial, Tips and Tricks of the Professional Database Administrator

This section is to give you the tips, tricks and a tutorial of everyday DBA database problems. You can learn SQL and how to access the data in tables, how to maintain triggers, constraints and how to create stored procedures. Have you ever tried to find the answer to a SQL problem you are working on and been frustrated by the solutions found on the web?

Here is a list of problems I have solved over the years. Ideally, I have presented the problem and a solution with all the pieces necessary to resolve the problem situation. I hate going to web sites and they show a small segment of code, that is the right code for your database/SQL problem, but you spend the next three days fishing for all the other script to finish your project.

Now, I don't plan to do all your work for you. It is your responsibility to read and study SQL and database administration, so you understand what is the right piece of the puzzle you need for your project.

If you are looking for specific information on C# programming, then check out the following links.

C#.Net

This SQL tutorial will provide you with the information you need to solve your SQL problems. You can learn SQL and we can help. You will find SQL basics, SQL intermediate and SQL advanced solutions to database analysis issues. So here is a list of links to problems I have solved.

Data Definition Language
Data Manipulation Language
What is a Database?
What is SQL?

Additions to our SQL and Database Pages

SQL DELETE Statement

A Powerful Command to Remove Rows from a Database The SQL DELETE statement is the most dangerous word in your arsenal of SQL statements. With one word and a table name you can inadvertently delete every row and column in a table. Use the following information cautiously...

SQL INSERT Statement

The SQL INSERT statement is used to add rows to a table or view. When you want to add information to a table you use the INSERT keyword. This is different from the UPDATE statement because when using the UPDATE statement you are changing information in a row. With the INSERT statement you are adding new information to the table.

Power of the SQL SELECT statement

Select Statement You can write SELECT statements and bring back information from any database. The SELECT statement retrieves information from the database. You can select information from one row or many rows, one field or column or many columns and from one table or many tables.