Categories
Tags → Sql Tutorial

Simple Database Class

This database class handles Select, Insert, Update, and Delete. It also takes steps to ensure your SQL syntax is valid, and that memory leaks / errors are prevented. Tutorial comes with demo, downloadable code, and an in depth explanation.
DETAILS

Oracle 10g Administering and Managing Users

This tutorial explains the ways and steps of creating and managing database accounts, Creating Users through Sql Plus, Creating User through iSQL*PLUS, Creating Users through EM, Manager Users, Managing Users through sqlplus and Managing Users throug...
DETAILS

Connecting to a SQL database from ASP .NET II

This is part II of the tutorial that teaches you how to connect to a SQL database from ASP .NET using SQL Authentication. This part shows you how to connect to the database using ASP .NET code and Visual Studio .NET''s features.
DETAILS

Connecting to a SQL database from ASP .NET I

This is part I of the tutorial that teaches you how to connect to a SQL database from ASP .NET using SQL Authentication. This part shows you how to set up MSDE for Mixed Mode and how to use Web Data Administrator to create databases and users.
DETAILS

Creating JDBC SQL Statements. Displaying Records from a MySQL Database.

A tutorial on how to create and execute JDBC SQL Statements and display records from a table in a MySQL Database. Also covers topics like creating databases and tables in MySQL. All code is explained in detail.
DETAILS

Formatting Date/Time value in SQL query

Learn how to use MySQL embedded function to format Date/Time field value just right in the SQL query string. For example another way is to use PHP, but it is slower and inconvenient. This tutorial will show you both examples for the same goal.
DETAILS

2 Ways of Displaying Data from an SQL Server Database using ADO.NET.

A step-by-step tutorial which explains 2 ways of displaying data from an SQL Server database using ADO.NET in an ASP.NET page. Every step has been explained in detail. Online demo and source code available for download.
DETAILS

Incorporating SQL Server 7.0/2000 Databases into your ASP Pages

This is a comprehensive tutorial on how to incorporate SQL server 7.0/2000 databases into your ASP pages. Topics include: Installation steps, Creating SQL Server 7.0/2000 Databases, Creating SQL Server 7.0/2000 Tables, Creating SQL Server 7.0/2000 Lo...
DETAILS

A Tutorial on Porting MySQL code using ADODB

In PHP every database is accessed slightly differently. To connect to MySQL, you would use mysql_connect(). When you decide to upgrade to Oracle or Microsoft SQL Server, you would use ocilogon() or mssql_connect() respectively. What is worse is that ...
DETAILS

Setting Up a MySQL Based Website - Part I

This is a step-by-step tutorial on how to set up a guestbook using a perl and a MySQL backend. This SQL backend application would be ideal for companies such as GuestWorld who run free public guestbooks.
DETAILS

Page:
©2019 A--9.com