how to connect to MS SQL Server from ASP classic code.

article from orafaq.com

There are multiple ways to delete the duplicates in the tables. Here is just some options.

There several ways to turn off automatic logon in Windows XP. See the details in this articlec

http://www.sina.com.cn 2009年06月15日09:46 家庭保健报
by 中国人口专业委员会 陆曙民

ASP.NET Mobile Control: ObjectList Control

Mobile Web Forms in Visual Studio 2008

6月2日，新东方教育科技集团董事长兼首席执行官俞敏洪，莅临同济大学，为同济学子做主题为“度过有意义的生命”演讲。(original link sina blog

original article url: http://office.microsoft.com/en-us/access/HA010547271033.aspx

from Sina.com // http://edu.sina.com.cn/en/2009-05-22/161651556.shtml

IT人35岁前的积累 from (CSDN)

Bet the drug companies won't like this one getting around.

(一篇很好的文章)

From csdn.net (http://topic.csdn.net/u/20081107/16/4B8869BA-5F81-4736-9DCB-F0BACAA8B27A.html)

周总理气死西方人经典语录
摘自‘新浪论坛’ url: http://bbs.book.sina.com.cn/tableforum/App/view.php?bbsid=16&subid=5&fid=175606&tbid=7951

幸福婚姻法则

Manual and Clean Uninstall Oracle for Windows
URL: http://www.mydigitallife.info/2005/12/13/manual-and-clean-uninstall-oracle-for-windows/

甚麼是 AQ?

url http://bytes.com/forum/thread554150.html

URL: http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.dotnet.languages.vb&tid=e5f83bd6-1f0b-43eb-b3fe-f4f48d924226&cat=&lang=&cr=&sloc=&p=1

URL: http://www.codeguru.com/vb/controls/vbnet_controls/datagridcontrol/article.php/c15137

URL http://www.codeproject.com/KB/reporting-services/ReportExporters_WinForms.aspx

URL: http://www.c-sharpcorner.com/UploadFile/mgold/ExerciseTracker02272006010240AM/ExerciseTracker.aspx

URL http://www.themssforum.com/VB/export-datagridview-415093/

url: http://msdn.microsoft.com/en-us/library/ms175915.aspx

URL: http://chiragrdarji.wordpress.com/2007/03/05/storing-and-retrieving-image-in-sql-server/

URL: http://www.softwareandtools.com/index.php/2005/11/28/saving_images_as_blob_into_sql_server_2005?blog=7

URL: http://forums.asp.net/t/1295549.aspx

url: http://support.microsoft.com/kb/308042/en-us

url: http://www.codeproject.com/KB/database/ImageSaveInDataBase.aspx

How to load a photo file to SQL Server 2005
http://www.trigonblue.com/Text_Market/Load_Image_to_SQL_Server_2005.htm

How To Disable Close Button in Windows Form URL: http://www.devasp.net/net/articles/display/307.html

Microsoft Help and Support
url: http://support.microsoft.com/kb/827218

from David Fekke blog, url: http://www.fekke.com/blog/index.cfm/2005/9/18/isnumericfunctioninmstsql

on July 12, 2007 by pinaldave, url: http://blog.sqlauthority.com/2007/07/12/sql-server-validate-field-for-date-datatype-using-function-isdate/

url: http://www.sommarskog.se/dynamic_sql.html | ...

url: http://asptutorials.net/SQL-Server/sseutil-and-database-replication/ | This article discusses how to copy databases from one computer to another. This is a typical problem to face if you have a development version of your system and you want to copy this over to a live version, or simply if you want to make a backup of a live system.

URL: http://msdn.microsoft.com/en-us/library/ms188001.aspx | It is SQL Server 2005 Online Books, regarding to "sp_executesql". Executes a T-SQL statement or batch that can be resued many times, or one that has been built dynamically.

URL: http://blogs.techrepublic.com.com/datacenter/?p=306 When you need to solve a tricky database problem, the ability to generate SQL statements is a powerful tool.

杨澜七年前震动世界的经典演讲
http://haoge85.blog.sohu.com/94441663.html

url: http://forums.asp.net/t/1252909.aspx

by Barry Dobson
http://www.barrydobson.com/2008/06/13/working-with-ldap-in-vbnet/

by Chandrashekhar Kulkarni
http://www.codeproject.com/KB/IP/LDAP_Using_VBnet.aspx
This article will explain how to access LDAP service using VB.NET.

http://www.planet-source-code.com/vb/tutorial/asp/samples/gbpaging.html

By Al Hetzel
http://www.15seconds.com/issue/000810.htm

url: http://www.15seconds.com/issue/990603.htm by Richard Bundock

以 弗 所 書 Ephesians

以弗所書 四章 17 – 五章 4

orignal url: http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/

Author: Thiru Thangarathinam URL: http://www.15seconds.com/issue/050721.htm

url:http://www.sapbrainsonline.com/ARTICLES/TECHNICAL/ARCHITECTURE/SAP_R3_ARCHITECTURE_introduction.html

url: http://www.sapbrainsonline.com/Emerging_Tech/XI.html
SAP Exchange Infrastructure (SAP XI) is SAP's enterprise application integration (EAI) software, a component of the NetWeaver product group used to facilitate the exchange of information among a company's internal software and systems and those of external parties.

url:http://www.sapbrainsonline.com/ARTICLES/TECHNICAL/SAP/SAP%20Business%20One.html
http://www.sapbrainsonline.com/ARTICLES/TECHNICAL/SAP/SAP%20Business%20One.html

url: http://www.sapbrainsonline.com/ARTICLES/TECHNICAL/SAP%20Netweaver/SAP%20NetWeaver%20Components%20&%20Tools.html
SAP NetWeaver includes a comprehensive set of components and tools.

url:http://www.sap.com/platform/netweaver/components/bi/index.epx

url: http://www.sap.com/platform/netweaver/components/applicationserver/index.epx
SAP NetWeaver Application Server brings together a proven infrastructure with the interoperability and flexibility of Web services technology. With this component of SAP NetWeaver, you get support for platform-independent Web services, business applications, and standards-based development.

url: http://www.sapbrainsonline.com/Emerging_Tech/sap_netweaver.html
SAP NetWeaver is SAP's integrated technology platform and is the technical foundation for all SAP applications since the SAP Business Suite.

url: http://www.sapbrainsonline.com/
SAP (System, Applications and Products in Data Processing)

url: http://www.databasejournal.com/features/mssql/article.php/1458091

「我日用糧」 / 李家同

URL: http://www.aspfree.com/c/a/Windows-Scripting/User-Interaction-with-Common-Dialogs-in-WSH/

humor reading about marriage. the conversation between the couple or lovers

Humor is something everyone needs but never notices. Let us read it in 2 min with 3 min laughing and 1 hour thinking.

This VBScript can be used to delete old folders. URL: http://www.databasejournal.com/scripts/article.php/3369851

This VBScript allows you to search files that are a few days old, in a folder for a keyword. It is useful to search files like archived log files in the same folder so that you can look in to only those log files which have the keywords. url: http://www.databasejournal.com/scripts/article.php/3376241

This script will send a simple email using CDOSys. URL: http://www.databasejournal.com/scripts/article.php/3500311

This script tests connectivity to SQL server box from a client machine when there is no SQL Client installed. URL: http://www.databasejournal.com/scripts/article.php/3494931

The script will delete old files from a given folder and all subfolders. URL: http://www.databasejournal.com/scripts/article.php/3517231

From the two tough questions, you will learn a lot meaningful tips for your life. Let's see.

from www.codeguru.com auther: Hannes du Preez

《军营-使我成长的地方》
作者： 刘晓生

在一家餐厅里发现了这篇文章，觉得不错，想和大家一起分享。 有些观念会随着时间，背景的不同而改变，而有些观念则会刻骨铭心，成为一生的追求。 url: Original Link

年轻时胆固醇高　日后易患心脏病 網址：http://health.zaobao.com/pages1/medicine200700.html

结肠直肠癌的病因和预防 網址：http://health.zaobao.com/pages3/specialists020302.html

作者：林桂叶 (2003-06-25) 網址：http://health.zaobao.com/pages3/specialists250603.html 高血脂症是一种无声的杀手。它与高血糖、高血压即是主凶，也是帮凶。它们互相影响，狼狈为奸。

哲理短文 URL: http://www.haha365.com/zldw/164641.html

哲理短文 URL: http://www.haha365.com/zldw/20051201100116.htm

哲理短文 URL: http://www.haha365.com/zldw/20051201095739.htm

两只猪的爱情

There is a lack of support for SQL Server's CASE function in Access SQL. After searching, googling on the internet, I found something useful online and shared it here. The URL I found is "http://ewbi.blogs.com/develops/2006/02/adding_case_to_.html". If you like, you can check the original article. Here I just list the step by step procedure to make it work in Access SQL. (June 11, 2007)

Provide helpful hints alongside certain form fields to guide your users on how to fill them out with this elegant script. A hint pops up only when the field is question has the user focus.

What is ISNULL (T-SQL) function and how to use it?

String Manipulations with SQL Server 2000 string functions in T-SQL

remove duplicate lines from text file

作者：刘晓生
我们每个人都应生活在感恩的世界里， 去感激曾伤害过你的人，因为他们磨练了你的心志。感谢那些曾欺骗过你的人，因为他们增进了你的见识。感谢绊倒你的人，因为他们强化了你的能力。我却很想感谢一次次痛苦的失败。饱尝了失败的挫折后，一片片无霞的蓝天出现在失败后。

url: http://classicasp.aspfaq.com/email/how-do-i-send-e-mail-with-cdo.html

url: http://www.microsoft.com/technet/scriptcenter/resources/qanda/nov06/hey1117.mspx
source: Microsoft Scripting guys

url: http://www.microsoft.com/technet/scriptcenter/resources/qanda/oct06/hey1010.mspx
source: Microsoft scripting guy

url: http://www.microsoft.com/technet/scriptcenter/resources/qanda/jun06/hey0622.mspx
source: Microsoft scripting guy.

url: http://www.daqi.com/bbs/20/1202820.html 令人喷饭的短信幽默 (孔子曰;打架乃用砖头乎.不宜多乎,用力乎.不宜乱乎,照头猛乎.佛曰;我佛慈悲,应拿刀砍,用力砍,照头猛砍！！！)

url: http://www.microsoft.com/technet/scriptcenter/resources/qanda/oct04/hey1014.mspx source: Microsoft Scripting Guy.

url: http://www.microsoft.com/technet/scriptcenter/resources/qanda/oct04/hey1020.mspx source: Microsoft Scripting Guy.

from vbforumns.com/showthread.php?t=453215

顧明明 47期，4月7日2007

作者：鍾世豪 牧師 47期， 4月7日2007

作者：那暁文 47期，4月7日2007