Archive for the ‘Database’ Category
SQL Select random row from table
Posted by: tzuhsun on February 17, 2009
UDF, User Defined Functions in MSSQL
Posted by: tzuhsun on February 13, 2009
Check no record in ADO
Posted by: tzuhsun on December 27, 2008
Reset auto-increment ID to some number
Posted by: tzuhsun on October 29, 2008
Remove redundant records
Posted by: tzuhsun on October 24, 2008
Set Rowcount [#] for paging
Posted by: tzuhsun on October 22, 2008
SELECT COUNT (with some conditions here) to return total rowcount for desired value only
Posted by: tzuhsun on October 20, 2008
