article from orafaq.com

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

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

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

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

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.

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/

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)

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

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