Archive for February, 2008
Friday, February 29th, 2008
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 close your session.
I found out it very useful if I want to do patching or debugging with my data and many more reason for me to use it.
Below are few simple way how you can play around with temp table.
Wednesday, February 27th, 2008
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,
MGR_NBR INT NULL
Populate sample data
INSERT INTO #EMP_MASTER VALUES (1, ‘DON’, 5)
INSERT INTO #EMP_MASTER VALUES (2, ‘HARI’, 5);
INSERT INTO #EMP_MASTER VALUES (3, ‘RAMESH’, 5);
INSERT INTO #EMP_MASTER VALUES (4, ‘JOE’, 5);
INSERT INTO #EMP_MASTER VALUES (5, ‘DENNIS’, NULL);
INSERT INTO #EMP_MASTER VALUES (6, ‘NIMISH’, 5);
INSERT INTO #EMP_MASTER VALUES (7, ‘JESSIE’, 5);
INSERT INTO #EMP_MASTER VALUES (8, ‘KEN’, 5);
INSERT INTO #EMP_MASTER VALUES (9, ‘AMBER’, 5);
INSERT INTO #EMP_MASTER VALUES (10, ‘JIM’, 5);
The aim of this query is to find all those employees who are not managers. The person is consider manager when MGR_NBR field is NULL.
hmm… query looks ok but the result is not.
Wednesday, February 27th, 2008
I’m having weird problem while posting to my wordpress blog using blogdesk.
HTTP Errorcode: 406
Googling around and the solution given is to add a few line in htaccess file.
I’ve update my htaccess file using that solution but no luck.I’m having 500 Internal server error instead after the changes.
Change htaccess file in root folder also give me same error.
I still can post using wordpress interface, but it is quite some time I have not using this features.
Any solution my dear friend ?
SOLVED. I don’t know what is the root cause. I have not done any changes since my previous attempt failed. maybe my hosting provided did something.
updated via -
Thursday, February 21st, 2008
I received ubuntu CD long time ago. It’s is version 6.06 LTS. Few days ago I start installing ubuntu dual boot with my existing Window XP.
Since my streamyx is up and running, ugrading to new version went smoothly.
For malaysian, you can visit http://ubuntu.com.my/ if you are having problem with ubuntu.There are a lot of experts that can help and give their expertise advice.
Here is my ubuntu Gutsy screenshot.
Now I have new thing to explore.
Friday, February 15th, 2008
Finally…i can update my blog using my own streamyx in my own sweet home .
All the while I’m updating my blog using internet connection in my office,cyber cafe,my mother in law neighbourhood “FREE” streamyx connection and any other place except my home.
Setting up my home wireless connection using Linksys WAG200G Wireless-G ADSL2+ Router is very easy ( after done some googling…of course)
The important thing is,make sure to update VPI/VCI value similar like below. everything else is just a straight forward
Hopefully I can blog more often after this.
p/s : life must goes on…