Archive for the 'Database' Category

DBDesigner - Free Data modeler

DBDesigner4 from fabFORCE.net, is a nice FREE tool for data modelling that I use for quite some time.

DBDesigner 4 compares to products like Oracle’s Designer©, IBM’s Rational Rose©, Computer Associates’s ERwin© and theKompany’s DataArchitect© but is an Open Source Project available for Microsoft Windows© 2k/XP and Linux KDE/Gnome. It is release on the GPL.

I like [...]

Utilizing ms sql temporary table

There are two types of temporary table in ms sql : local and global temporary table. You can read it further about that here and here.
For me, the best thing I found about this is that, this table will be created in tempdb table and it is only for temporary.It will be gone once you [...]

SQL - Not In vs Not Exists

I have stumble upon this great website talking about difference between “NOT IN” vs “NOT EXISTS” in SQL.
I’ve follow the step and create same table structure with same sample data into my temporary ms sql table.

Create temp table.
CREATE TABLE #EMP_MASTER
(
EMP_NBR INT NOT NULL PRIMARY KEY,
EMP_NAME VARCHAR(20),
MGR_NBR INT NULL
)
Populate sample data
INSERT INTO #EMP_MASTER VALUES (1, ‘DON’, [...]

MS-SQL - List trigger in your db.

Trigger is special set of SQL code where activation is caused by modifications to the tables. (by an INSERT,DELETE or UPDATE).
Trigger is associated with database table, so if you want to find it from your SQL Enterprise Manager or your SQL Query Analyzer, you need to go table by table to find where the trigger [...]


AWSOM Powered