dbWriter.com

[Your location country flag]	[Your IP - 38.107.191.111]	Tuesday, February 09, 2010

dbWriter Home

IP to Country Look up

Site Map

IP to Country DB

Free Databases:

ASP Code

ASP Links

VB Script functions:

Array

Case/Select

In String (inStr)

Replace

HTML code:

SELECT Color

SELECT Countries

SELECT Language

SELECT State/Province

SQL:

SQL Functions:

Delete leading Char

Get Browser

Long number from IP

Stored Procedures:

SQL Tricks:

Delete ALL duplicates

Delete dup records

MISC

IP Address Owner

MS SQL Server

Mortgage Calcs:

how much is my payment

Link to US

Links

The new SQL Server Management Studio database connection time is ten times faster than the old Enterprise Manager ON the web. I have waited and waited for Enterprise Manager to load up with just a few of the databases on the server. SQL Server Management Studio comes up is the web SQL tool to use for SQL2005 OR SQL2000!!

Download SQL2005 express for free

Download VB2005 express for free

Download Visual C# express for free

Take dbWriter's FREE SQL database shopping cart for a test drive. Contact us for asp and SQL code.

Latest dbWriter SQL tricks

As you know it is difficult to get rid of duplicate records in a SQL database.
There are a lot of scripts out there that will find them for you BUT deleting them will only cause an error because the server cannot distinguish between them.

THE FIX:

Modify the SQL table and add a unique integer identity column to the table.
This will make each row unique and then you can delete or leave any row YOU chose!!!

Then you can remove the column if you wish BUT without it you will have the same problem in the future.

Latest code and database UPDATES

ASP Bar Code Generator This ASP code will build printable bar codes .

SQL last two week adjust This code will automatically update you view of data to include data starting 14 days prior.

SQL time adjust from server time Date and times are stored at the server, where ever in the country/timezone it might be thus a time adjust is needed when viewed in a different time zone.

ASP CAPTCHA

dbWriter.com SQL administrator e-mail Send an e-mail to the SQL server administrator with drive space problems.

dbWriter.com FREE Web Spider/Bots database

Components checker in access DB over 760 components loaded in an access database

Although every effort is made to ensure the accuracy of our free databases we cannot guarantee them being 100% accurate.

Partners/Links