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#
, then check out the following links.
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.
Additions to our SQL and
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
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
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.