SQL

(01) display the printable and space ASCII characters and their codes (02) bump up sequences (03) display a calendar with this PL/SQL procedure (04) check the free space in your database (05) DBMS_JOB job scheduler INTERVAL examples (06) delete duplicates in a table with one SQL statement (07) describe all tables and views (08) PL/SQL does_row_exist function (09) find all column check constraints

At your SQL*Plus prompt, play 6 games: A number-guessing game, a memory challenge, Pig, Shut The Box (pictured), a virtual 3x3 slide puzzle, and Tic-Tac-Toe. Also Included: The virtual Magic 8-Ball. Enjoy!

Introduction: This tutorial will cover creating a register form with PHP/MySQLi/HTML. Steps of Creation: Step 1: First, we need to create a database to hold the user accounts. This is done through MySQL/PHPMyAdmin. On your localhost/web host cPanel/Control Panel go to MySQL Databases and create a new one (for example; the name of your site - Mine will be "tutorial"). Next, go to PHPMyAdmin and

A great way to learn database programming is to have a good sample database with lots of tables and appropriate relationships between them to work with. Queries can then be composed from within a variety of programming platforms, such as Java, PHP, Visual Basic 6, Visual Basic.Net, Visual C#, etc. NorthWind is a free sample database that Microsoft included with every version of Access going all

In this tutorial I am going to teach you one of the most important MySQL techniques that you must use in your software development. Today huge amount of business use MySQL as their data base. Imagine if their database corrupted what would be happen ?, If your server crashed what word you do ? So we must use database backup technique to overcome those issues. Now I am going to explain you one of

Modern day software application has millions of concurrent users. Development of efficiently serviceable application needs huge amount of effort, usage of lot of tools and techniques. Software developers always try to improve performance of the application by improving design, cording and database development. When we consider database development query optimization and evaluation techniques are

Introduction: This tutorial will cover creating a login form with PHP/MySQL/HTMl. Pre-creation: First you need to have some user accounts stored in a database, you can check out my profile for a tutorial on creating a register form. Steps of Creation: Step 1: First we need to connect to the database holding the user accounts... mysqli_connect uses the parameters; server, username, password* Step 2

Most of the time, we encounter duplicate records in our database. And it's not easy to delete it if you don't have enough knowledge about SQL Statement. This code will help you detect and delete duplicate records in SQL Server 2005 and above. (These commands only works on sql server 2005 or higher) Create table create table example(id int identity(1,1),name varchar(20),class varchar(20)); (Here

hi friends it is SQL Injection Attack, try it and it's cool and easy.

This is Database in sql server 2008 all operation by Santosh Rai