SQL Server: Relationships

In a previous article, I spoke about Referential Integrity within SQL Server when migrating from Microsoft Access. For the same audience, this article shows how to create a “Database Diagram” similar to the ones that can be created using the “Relationships” panel within Microsoft Access. To create a “Relationship” Diagram within SQL Server Before you … Continue reading SQL Server: Relationships


SQL Server: Referential Integrity

If you are used to enforcing referential integrity via the “Relationships” panel within Microsoft Access, you will quickly find things are done a little differently within SQL Server.  There are two methods available to help maintain referential integrity within SQL Server. Foreign Keys / DRI (Declarative Referential Integrity) Triggers / PRI (Procedural Referential Integrity) DRI … Continue reading SQL Server: Referential Integrity

Install: Microsoft SQL Server 2008 Management Studio Express

Download SSMSE 2008 here. The Management Studio is now built into the main SQL Server 2008 Express installation routine. To add SSMSE, ensure that “Perform a new installation of SQL Server 2008” is selected. Select “Management Tools – Basic” from the “Feature Selection” dialog box when prompted. That’s it! Note: if there are any issues … Continue reading Install: Microsoft SQL Server 2008 Management Studio Express

CodeCharge Studio & SQL Server 2005 Datetime

I recently migrated one of my Database from Microsoft Access to SQL Server 2005 Express. However, the Dates did not display at all in my PHP Forms. To ensure that SQL Server “Datetime” is displayed correctly, check the following settings within your CodeCharge Studio Project: Project => Settings => Locales & Encoding: “Date Display Format” … Continue reading CodeCharge Studio & SQL Server 2005 Datetime