CodeDoc

If you are here because you are getting the dreaded “Network error IOException: Connection Refused: connect in MS SQL Server 2000” error message with the MySQL migration toolkit and need a solution, then you have come to the right place. Read more…

From time to time, we may want to replace NULL values with some desired value when doing an sql select statement. Turns out that SQL Server makes this a simple task – and no IF statements are necessary! To do this, we use SQL Server's ISNULL function. This function takes two parameters. The first parameter is the name of the field that we expect may have a NULL value that we wish to replace. The second parameter represents the replacement value for the NULL value. Read more…