Free Source Code Projects and Tutorials

SQL UPDATE Statement

Submitted by admin on Mon, 02/28/2011 - 21:23

When you insert record to your table there are some cases that you need to modify the data. Or you may want to update it to the latest record.

The SQL update is there to help us modify the existing values of the table, the SQL update statement used the same column name as insert statement and the new value that you want to placed and the table name to update the data successfully.

The syntax of SQL update statement is as follows:

Simple 3D ^__^

Submitted by mrdobLedos on Mon, 02/28/2011 - 15:59

hahaha,,,i'm here again..mrdobLedos.. another very simple program entitled "Simple 3D" hope you will like it!!! improve this program if you like..then repost it.. thnx... ============= +639176985856 [email protected] =============

SQL INSERT Statement

Submitted by admin on Sun, 02/27/2011 - 20:26

SQL Insert command is used to save record into a database in a specific table.

The SQL Insert command has the following syntax:

SQL SELECT Statement

Submitted by admin on Sat, 02/26/2011 - 20:53

The select command is used to retrieve data from the tables.

Consider the following table:

Users:

SQL Syntax

Submitted by admin on Fri, 02/25/2011 - 20:54

SQL is not syntax strict like JavaScript which mean to say that in SQL uppercases and lowercases don’t matter as long as you have spelled them correctly.

For example:

SQL intro

Submitted by admin on Thu, 02/24/2011 - 22:17

SQL is an acronym for Structure Query Language, it is a language which helps program to communicate with the databases, regardless of the type of the database, the SQL syntax is almost the same except for extended commands which certain DBMS support or do not support or simply have its own versions or dialects.

Flash Card Addition

Submitted by mrdobLedos on Thu, 02/24/2011 - 08:50

let's Play!!! Heeheh.. ahm..just lyk my 2nd post... khapon ko lng din to gnwa.. COMMENT po kung anu msasabi nyo.. SOLOMOT.. ^__^

Simple Blackboard(Looks Like Paint)

Submitted by mrdobLedos on Thu, 02/24/2011 - 08:42

ahahahha..good day guyz... ive just created this program yesterday... wala kc mgawa so naisipan kong gwin toh.. wla lng..share ko lng BAKIT??? heheh..... Try nyo masaya toh,,,, Comment if anu msasabi nyo..hehe :)

PAGINATION USING LINQ (not a stone age technology)

Submitted by tony_fear2003@… on Thu, 02/24/2011 - 00:45

PROGRAMMER: WINSTON L. GUBANTES REFERENCES: VISUAL C# PROGRAMMING BY: BARBARA DOYLE VISUAL BASIC .NET HOW TO PROGRAM BY: DEITEL & TIM R. NIETO PURPOSE: USE PRIMARILY FOR MANIPULATING PAGINATION IN C# LANGUAGE: C# .NET

Weekly Sales Report using Crystal Reports

Submitted by admin on Tue, 02/22/2011 - 21:43

The following source code will teach you on how to create a “Weekly Sales Report” using Crystal Reports. The most important part of this project is the use of SQL Statement. Here’s the statement that create a weekly sales report. SELECT TOP (100) PERCENT CONVERT(Varchar, DATEADD(WEEK, DATEDIFF(WEEK, CONVERT(DATETIME, '1900-01-01 00:00:00', 102), Date), CONVERT(DATETIME,