Tech Sharing Blog

Check out the slide show to find out which blogger are you consider as?

Popularity: 1% [?]

Do you believe that the Search engine gaint are FAIL in math?

Google search engine calculator will display the wrong answer if you try to calculate the very large number. For example 2,999,999,999,999,999 minus 2,999,999,999,999,998 should be get the answer of 1, but google give the answer of “0″. Suprise?

You will only get the correct answer  2,999,999,999,999,999 minus 2,999,999,999,999,990 which the answer is 9.

The other example is 400000000000002-400000000000001, you will get the answer of 0 instead of 1, but 400000000000002-400000000000000 you will get the correct answer of 2 from Google calculator.

Basically this post is just for fun, I’m not sure what is the story behind the calculation error, maybe is a bugs, or maybe Google have their own explaination on it.

Popularity: 1% [?]

I try to google, call, msn my friend to find out the solution when I stay back in my office until late night yesterday. But still no luck after few hours of trying.

Thinking of gave up when back to office this morning, but one of my friend suddently send me the solution via MSN. That’s the best present I received by today. I’m not sure how many people will looking for this kind of solution, but any way, will post here to share with all and you may take it if you need it.

Basically the idea is that you put all your select, update or delete statment into the variable and use the execute command to execute the whole variable.

My problem:

I have a formula store in a table which is A+B*C+D. My A = 1, B=2, C=3, D=4.

I managed to replace all my variable with the integer using cursor (This maybe not a good solution, but this is not the main discussion in this post)

The finally answer I get is 1+2*3+4. But the bad thing is in the varchar datatype. I only manage to disply 1+2*3+4 but not the answer of 11.

The solution as below:

Declare @MathFomula Varchar(100)

Set @MathFormula = ’1+2*3+4′

Exec(‘SELECT ‘ + @MathFormula  + ‘ AS Result’

Output: 11

* Remember that * and / will calculate at first before + and -

Popularity: 2% [?]

Another new launch Gmail Labs features where you may preview your messages while waiting for the Gmail to be completely load. The new features is named as

“Inbox Preview”

If you are on the high speed internet connection, then this features may not benefit you. But try to imaging that you are on the very slow internet connect which may take several minutes to only completely load your inbox. How bore you are while you waiting for that and you find nothing to do besides look at the loading bar and counting the movement of the bar.

In addition, if you only found out that there is no any new message for you to read after servaral minutes of waiting, how disappointed you are.

Gmail always try the best to make their product become more user friendly you may have a static preview of your inbox with the 10 most recent messages on the screen.

What you need to do is just to turn the Inbox Preview features on in from the Lab tab under the settings.

Popularity: 1% [?]

I believe most of the advance computer user will know how to ultilize the window run command. But for the normal user may not ultilized it but more prefer to click by mouse.

The most common use command is [cmd] and also [notepad]. By using the window run command, you may just press on [Window Key] + [R] on your keyboard and type the command.

The following are some of the window run command that you may or may not use, but I suggest if possible try to remember the most common use which will help you to save your time and also reduce the movement of your hand.

Accessibility Controls
access.cpl

Add Hardware Wizard
hdwwiz.cpl

Add/Remove Programs
appwiz.cpl

Administrative Tools
control admintools

Automatic Updates
wuaucpl.cpl

Bluetooth Transfer Wizard
fsquirt

Calculator
calc

Certificate Manager
certmgr.msc

Character Map
charmap

Check Disk Utility
chkdsk

Clipboard Viewer
clipbrd

Command Prompt
cmd

Component Services
dcomcnfg

Computer Management
compmgmt.msc

Date and Time Properties
timedate.cpl

DDE Shares
ddeshare

Device Manager
devmgmt.msc

Direct X Control Panel (If Installed)*
directx.cpl

Direct X Troubleshooter
dxdiag

Disk Cleanup Utility
cleanmgr

Disk Defragment
dfrg.msc

Disk Management
diskmgmt.msc

[More]

Popularity: 1% [?]

I just found out this usefu function in MSSQL when I try to Google for the solution to replace the null value with something else. So that I no need to do the checking again in my application. The function is call

NULLIF and ISNULL

This 2 functions are actually work opposite with each other.

NULLIF(ColumnName, ValueToCompare) accept 2 parameters, and will return the NULL value if both the expression match.

IFNULL(ColumnName, NewValue) accept 2 parameters, the first parameters is the string that you wish you check with, and the 2nd parameter that you wish to replace with.

Popularity: 3% [?]