Monthly Archives: September 2012

Row_Number SQL Server

Posted on September 26, 2012 by hammadk

Row_Number or Sequence Generator in SQL Server Is is used to generate a sequence number or a row number in a result table. That is if you want to run a query and you rank certain records in certain order, … Continue reading →

Posted in SQL Server 2008 | Leave a comment

Solution – Preserve Leading Zeros in Excel

Posted on September 20, 2012 by hammadk

If you happen to copy data from somewhere to excel (such as a data in SQL format), you would have noticed that excel does not store leading zero. There are some solutions that lets you have exact number of leading … Continue reading →

Posted in Tutorials/Tips | Leave a comment

How to run javascript in asp net page_load

Posted on September 18, 2012 by hammadk

I tried writeline(“// “); but it did not work. Found out, you have to use RegisterStartupScript in order to run JavaSacript in ASP.NET page. More help is on MSDN

Posted in Tutorials/Tips | Leave a comment

Fix ASP.NET Menu Layout Issue in Chrome and Safari

Posted on September 17, 2012 by hammadk

I had this menu issue which would not render properly in Chrome and Safari but run ok in Internet Explore and FireFox. The following is the fix. Put the following code at the top of your Page_load() function of the … Continue reading →

Posted in Troubeleshoot | Leave a comment

How much does a doctor visit cost in the US?

Posted on September 12, 2012 by hammadk

For specialist without insurance it cost me $300 to visit dermatologist (specialist). This is extremely high just for 5 minutes of doctor. Waiting excluding, the doctor is not likely to spend more than 10 min with you. Even if you … Continue reading →

Posted in United States | Leave a comment

Reading null values from datatabase in C# code

Posted on September 12, 2012 by hammadk

If you tried reading a null value from the database such as a null date, you might have across this exception Specified cast is not valid Casting Nullable Values The following code works unless a null datetime is returned. Note … Continue reading →

Posted in Troubeleshoot | Tagged , , , , | Leave a comment

Bracketing on Nikon D5100

Posted on September 12, 2012 by hammadk

Nikon D5100 come with bracketing but it took me a while to use it. I will explain here how it be use. I am not impressed by it btw for the couple of pictures that I took with it just … Continue reading →

Posted in Tutorials/Tips | Leave a comment

Condition on null does not work with =

Posted on September 11, 2012 by hammadk

What do you expect from the following code? Will the block inside if be executed? IF ( @ID != NULL )   BEGIN       UPDATE inventory       SET    count = 5       WHERE  id = @ID   END  The statments inside If will never be executed because it will always evaluate false. The reason it equal (=) … Continue reading →

Posted in Troubeleshoot | Leave a comment

Object reference not set to an instance of an object.

Posted on September 10, 2012 by hammadk

How to troubleshoot Object reference not set to an instance of an object in C#. Put a break point in the code, execute the code Inspect the value where you are getting this error Inspect the value you are assigning … Continue reading →

Posted in Troubeleshoot | Leave a comment

Quick SQL Scripts

Posted on September 7, 2012 by hammadk

Find start date of the year in SQL SELECT Cast(Datepart(yy,Getdate()) AS VARCHAR(4)) + '-1-1' year  

Posted in SQL Server 2008 | Leave a comment