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 [...]
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’, [...]
I’m having weird problem while posting to my wordpress blog using blogdesk.
HTTP Errorcode: 406
NONE ACCEPTABLE
Googling around and the solution given is to add a few line in htaccess file.
<IfModule mod_security.c>
SecFilterEngine Off
SecFilterScanPOST Off
</IfModule>
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 [...]
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 [...]
