Archive for January, 2009

Get Number of Days in a Month Function

This article shows the ways to get the number of days in a month in both sqlserver and mysql.

Getting the number of days in a month is quite easy because it is going to be either 30 or 31 days, with the exception of February, which can either have 28 or 29 days depending if it is a leap year or not.

  • January,March,May,July,August,October,December — 31 Days
  • April,June,September,November – 30 Days
  • February – 28 Days (Non Leap Year), 29 (Leap Year)

Leap year should be divisible by 4, should not be divisible by 100 or should be divisible by 400.

(continue reading…)


Debug JAVA applications remotely with Eclipse

You don’t need to debug Java™ applications on just your local desktop. Learn how to spread around your debugging using different connection types that make up remote debugging. This article explains the features and examples that show how to set up remote application debugging.

Remote debugging can be useful for application development, such as developing a program for a low-end machine that cannot host the development platform, or debugging programs on dedicated machines like Web servers, whose services cannot be shut down. Other examples include Java applications running with limited memory or CPU power, such as mobile devices, or developers wanting to separate the application and development environments, etc.

please check this link to know more

http://www.ibm.com/developerworks/java/library/os-eclipse-javadebug/index.html?S_TACT=105AGX02&S_CMP=EDU

1 Comment more...

Permalinks on IIS6 (without mod_rewrite)

Pretty Permalinks are SEO / Human friendly urls for your blogs. Wordpress uses mod_rewrite module which is not supported by IIS.

If you are using IIS7 and have administrative privileges you can use Microsoft’s URL Rewrite Module , Read this for more information.

This article briefs about the technique used to make the permalinks work with IIS6.

(continue reading…)


A few maximum limitations for Sqlserver and MySql

Often people in newsgroups ask about maximum size of various objects defined in databases.

The following tables shows the maximum sizes and numbers of various objects defined in MYSql, SQL Server.


MySql Maximums
Char 255 Bytes
Varchar 65,535 Bytes
Binary 255 Bytes
Varbinary 65,535 Bytes
TinyBlob 255 Bytes
TinyText 255 Bytes
Blob 65,535 Bytes (2^16 -1)
Text 65,535 Bytes (2^16 -1)
Medium Blob 16,777,215 Bytes (2^24 -1)
Medium Text 16,777,215 Bytes (2^24 -1)
LongBlog 4,294,967,295 Bytes (2^32 -1)
LongText 4,294,967,295 Bytes (2^32 -1)
Bit Range from 1 to 64
Tinyint The signed range is -128 to 127. The unsigned range is 0 to 255.
BOOL, BOOLEAN true or false
SmallInt The signed range is -32768 to 32767. The unsigned range is 0 to 65535.
MediumInt The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215.
Int/Integer The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295.
BigInt The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range
is 0 to 18446744073709551615.
Float Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38
to 3.402823466E+38.
Double Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and
2.2250738585072014E-308 to 1.7976931348623157E+308.

(continue reading…)


Flux iPhone Wallpaper

I recently played around in Photoshop and came up with a combination of colors and shapes I really liked. So here is the brand new "Flux" wallpaper set for your iPhone and iPod touch. Enjoy!

  •   
  • Copyright © 1996-2010 BlogmyQuery - BMQ. All rights reserved.
    iDream theme by Templates Next | Powered by WordPress