Most recent posts

SQL UPDATE Using a Join 0

SQL UPDATE Using a Join

You may need to do an update on joined tables to get a more conditional update.  For instance, I have a Student table as well as an AcademicStatus table.  The Student table contains all the students (profound, I know) and...

0

Trouble Viewing Reports in Report Server

Have you ever opened your report server only to find a blank section of nothing-ness where your reports should be?  The solution to your problem is more than likely in the permissions.  The easiest fix for this situation is to...

0

Saving Changes Is Not Permitted

Have you ever created a table thinking everything looked amazing and was designed perfect only to come back and need to add to it?  Maybe you need to change a data type, add a column, delete a column or move...

0

Database Design

Designing a database can be a daunting task, especially on a large scale.  There are several ways inside of SQL Server Management Studio to do design.  You could create your database and right click on the ‘Tables’ node and enter...