2008-08-05から1日間の記事一覧

Project Euler 4

Project Euler Problem 4 A palindromic number reads the same both ways. The largest palindrome made from the product of two 2-digit numbers is 9009 = 91 99.Find the largest palindrome made from the product of two 3-digit numbers. A palindro…

SQL server 2003でTEXT型の文字数を数える

TEXT型を一度nvarchar型(unicode)に変換し、LEN関数で数える SELECT LEN(CAST(text_colum AS nvarchar(4000))) FROM table_name SQL server 2005以降は、nvarcharの最大項目長が2Gまでだが、 SQL server 2003ではnvarcharの最大項目長が4000文字までとなっ…