t-sql
Insert Triggers
An insert trigger is a Data Manipulation Language (DML) trigger that acts when a new record is added to the table. CREATE TRIGGER t_tableName_insert ON
SQL102
SQL102
SQL 102 – REVOKE
Like I mentioned previously REVOKE is like an undo function for GRANT and DENY. If you have a developer and you work with him for a while, you may find that
dba
SQL 102 – DENY
Alright, at this point you should know how to GRANT permission to a database object, but do you know how to DENY permission to an object? DENY uses a syntax
SQL102
SQL 201 – Contstraints
Constraints... helpful in making sure you get the data you want out of your database! Constraints allow you to define rules that the data must follow in order
t-sql
Triggers
Triggers are one of the most misunderstood features in Microsoft SQL server. Most of that misunderstanding comes from people implementing triggers with little
dev
Default Values
When you start creating tables and setting them so they can't have NULL values, you'll eventually need a way to define a default value for the column. A default
microsoft sql
Identity Columns
An IDENTITY column is a column that automatically gets it's value set by the database engine when a new record is added. This is one of the oldest ways
t-sql
Computed Columns
What is a Computed Column A computed column is a column that users will not enter data for, but the SQL Server will compute and store a value in. The expression
Posted in: Microsoft SQL
Schema
In previous versions of SQL Server we had what we called "owners" of objects. Nearly every time you talked about an object "owner" you were talking about dbo.
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
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
SQL102
DROP and Truncate
It's only a matter of time before you need to clean up after yourself in Microsoft SQL. You'll have to get rid of an index, or a table, or maybe even a whole