Archive

Posts Tagged ‘SQL Server’

Resolving Connection Error with MySQL Migration Toolkit

June 2nd, 2010 Pierre Buckley 5 comments

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…

Handling Null Values in SQL Server

May 28th, 2010 Pierre Buckley 5 comments

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…

Categories: SQL Server Tags: , ,

Starting ASP.NET Programming

March 8th, 2007 Pierre Buckley 11 comments

Okay, I haven't updated this blog in a while. The reason is i am bogged down with tons of school work. At the moment, I have being doing a lot of ASP.Net and thought that I would just write this quick guide to help the noobs out there to get started in programming with ASP.Net. As always, you need to have some prerequisite knowledge and tools to get started. Read on… Read more…

  • Twitter
  • Buzz
  • Facebook