Nov 20 Good News Everyone! It’s been a while since I’ve been on here, but I have good reasons. I’ve been working at my current employer for three and a half years. I no longer see this place in a positive light. So I’ve worked hard to find a better...
SQL102
Introduction OK, we all know that when we create objects in a database, we're using Data Definition Language (DDL) commands. Every time we create an object,
career development
If you're not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the
career development
If you're not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the
Posted in: Microsoft SQL
OK, so we’re all familiar with triggers now, right? You have seen that using a trigger you can log a change to a table in a special log file, or we can create a related record in another table. But all of these events happen after the action that triggers...
SQL201
Transact SQL (T-SQL) has two main wait of passing data, variables, and parameters. A variable is an object in T-SQL batches and scripts that can old a value.
SQL201
When you want to build more intelligent or more flexible T-SQL scripts, you're going to need to know how to control the flow of the program. You'll need the
SQL201
Errors can have different levels of severity. Based on this severity, you may wish to handle the error in different ways (see my articles on TRY..CATCH). In
SQL102
OK, What do you know about triggers? Did you know you can use them to run a bit of T-SQL on data changes? Those would be called Data Manipulation Language
dba
I just wanted to share a quick script that I used to help re-index all the tables in my database. If you have any questions about it, please let me know! USE
career development
If you're not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and
microsoft sql
When building solutions in T-SQL, you'll often be asked to generate a change script. This change script is a batch of SQL statements that when executed