SQL PHP HTML ASP JavaScript articles and free scripts to download

ASP Ajax Date & time Array Form Server.MapPath Request Objects Response Objects MSSQL File System String ASP Mail

MS SQL Database

MSSQL is a database offered by Microsoft. This is not a free database but available for developers for testing. Many web applications, data centers etc uses MSSQL database.

Downloading MSSQL

You can buy MSSQL database. For testing and developing download MSSQL 2008 R2 Express edition for free. SQL Server 2008 R2 180 days trail pack can be downloaded. Visit Microsoft MSSQL website for more details.

You can download the online book on MSSQL Server 2008

Licenses for use.

To understand different types of Licenses and what is best for you, visit or download this PDF file on Licenses from here

After Installing MSSQL connection from ASP

Create Tables , checking records, displaying records etc

DateTime Functions of MSSQL database

Using Queries to get or update data from MSSQL

MSSQL Database with Examples

Connecting string for MSSQL database in VBScript

Checking if matching record exist inside MSSQL table

Creating New Table using MSSQL Enterprise Manager

Displaying Records of a MSSQL table by looping

Creating Auto Increment Identity field for generating unique record number

Getting the Auto Increment Identity field value for just inserted record

ROWCOUNT : Number of rows affected by any update or delete command in MSSQL table

Post Comment This is for short comments only. Use the forum for more discussions.
Name
Email	( not to be displayed)Privacy Policy
1+2=	This is to prevent automatic submission by spammers. Please enter the result of the sum as asked



Join Our Email List Email:

For Email Newsletters you can trust

MSSQL

Connecting string Checking record Creating New Table Displaying Records Auto Increment Identity field Identity value ROWCOUNT

MSSQL Connection DateTime functions MSSQL Query