http://www.alectang.com A developer who always get inspired by the latest. Thu, 24 Jul 2008 10:24:19 +0000 http://backend.userland.com/rss092 en When working with sql, sometimes we have to declare a variable to hold text, ntext. But it's not going to work if we declare a varchar to hold text. It will throw error: Server: Msg 2739, Level 16, State 1, Line 1 The text, ntext, and image data types are invalid for ... http://www.alectang.com/blog/aspnet/the-text-ntext-and-image-data-types-are-invalid-for-local-variables/ In SQL 2005, we usually use row_number function to do pagination, but that is not available in SQL 2000. So the following would be useful: DECLARE @first_id int, @startRow int SET ROWCOUNT @StartIndex SELECT @first_id = ATC_Article.id FROM ATC_Article INNER ... http://www.alectang.com/blog/aspnet/use-rowcount-for-pagination-in-sql-2000/ Some sql queries to remember: To change the data type of an existing column: alter table big_photos_temp alter column mainPhoto_id int To add a new column alter table big_photos_temp add mainPhoto_id intShareThis http://www.alectang.com/blog/aspnet/addchange-column-data-type-in-sql-2005/ Baidu has announced its beta version of messenger, called Baidu Hi!. To try it out, simply visit here. ShareThis http://www.alectang.com/blog/webmaster-info/baidu-announced-beta-release-of-its-im/ As China started its national mourning for three days, most websites and major portals have been presented as grey out mode. These include all of the most used search engines in the mainland plus all entertainment websites. Yahoo! China Baidu China Sina Sohu BT ChinaShareThis http://www.alectang.com/blog/webmaster-info/chinese-websites-grey-out-for-3-days-mourning/ I have been trying hard to find out how to go through a list of columns and find and replace some string to what I want. Most of the online tutorials use cursor to do this, but somehow it did not work for me. The following is the script that ... http://www.alectang.com/blog/aspnet/sql-how-to-find-and-replace-text-in-columns/ Since 4 days ago, one of my blogs which runs with great traffic started showing sign of slowing down. Never have I seen this kind of down turn before, that it seems more like a server issue or something. From 100% to 50% to 20%. At first, I thought it ... http://www.alectang.com/blog/webmaster-info/wordpress-footer-template-hacked-badly/ Sometimes when you have link to images and you don't want them to be opened by IE but prompt for download/ save, your browser will "understand" certain file types, so if you navigate to an image file such as .gif, .jpg, .png, it will display the image because it knows ... http://www.alectang.com/blog/php-lab/how-to-prompt-for-download-image-instead-of-opening/ Was seeking a way to let different windows talking to each other. Something like a link in a pop up window, when clicked, the original window's text box will be filled with some text. Example can be seen here.ShareThis http://www.alectang.com/blog/webmaster-info/use-javascript-to-talk-between-windows-pages/ Yahoo! Kimo has announced to launch online credit card payment system for its online auction section! This is a great news as previously, if you want to purchase something in the auction, you'd have to pay local or do an Internet banking transfer. But now, for sellers who met over ... http://www.alectang.com/blog/webmaster-info/yahoo-taiwan-offers-credit-card-payment-in-auction/