soundex

--Statement function --Data manipulation SELECT-Retrieve rows and columns of data from a database table INSERT-Add new data rows to a database table Delete-Deletes rows of data from a database table Update--updating data in a database table --Data

Beginner transact_sql******************** --Statement function --Data manipulation SELECT-Retrieve rows and columns of data from a database table INSERT-Add new data rows to a database table Delete-Deletes rows of data from a database table Update--

Drop view-Removing views from the database Create index--creates an index for a database table Drop INDEX--deletes an index from the database Create PROCEDURE--Creating a stored procedure Drop PROCEDURE--removing stored procedures from the

--Statement function --Data manipulation SELECT-Retrieve rows and columns of data from a database table INSERT-Add new data rows to a database table Delete-Deletes rows of data from a database table Update--updating data in a database table --Data

transact_sql******************** --Statement function --Data manipulation SELECT-Retrieve rows and columns of data from a database table INSERT-Add new data rows to a database table Delete-Deletes rows of data from a database table Update--updating

Delphi6 function Daquan 1-strutils.pas Header function Ansiresemblestext (const atext, aother:string): Boolean; $[strutils.pasFeature returns whether two strings are similarDescription ANSI (American National Standards Institute) American State

Mathematical functions 1. Absolute value S:select ABS ( -1) value O:select ABS ( -1) value from dual 2. Rounding (Large) S:select Ceiling ( -1.001) value O:select ceil ( -1.001) value from dual 3. Rounding (small) S:select Floor ( -1.001)

  Basic SQL knowledge1. database query: Select usageSelect [top (numeric)] field list from data table [Where condition] [order by field] [ASC or DESC] 2. Add data: insert into usageInsert into data table (Field 1, Field 2, Field 3 ,...) Values

********************-- Sentence skill-- Data OperationsSELECT -- retrieve data rows and columns from database tablesINSERT -- add new data rows to the database tableDELETE -- DELETE data rows from a database tableUPDATE -- UPDATE data in the

= SQL statement collection =- -- Sentence -- skill -- -- Data OperationsSelect -- retrieve data rows and columns from database tablesInsert -- add new data rows to the database tableDelete -- delete data rows from a database tableUpdate -- update

-- Sentence skill-- Data OperationsSELECT -- retrieve data rows and columns from database tablesINSERT -- add new data rows to the database tableDELETE -- DELETE data rows from a database tableUPDATE -- UPDATE data in the database table-- Data

-- Sentence skill-- Data OperationsSelect -- retrieve data rows and columns from database tablesInsert -- add new data rows to the database tableDelete -- delete data rows from a database tableUpdate -- update data in the database table-- Data

-- Sentence skill -- Data Operations Select -- retrieve data rows and columns from database tables Insert -- add new data rows to the database table Delete -- delete data rows from a database table Update -- update data in the database table -- Data

[Code = SQL] [/Code]-- Sentence skill-- Data OperationsSelect -- retrieve data rows and columns from database tablesInsert -- add new data rows to the database tableDelete -- delete data rows from a database tableUpdate -- update data in the

-- Sentence skill -- Data Operations SELECT -- retrieve data rows and columns from database tables INSERT -- add new data rows to the database table DELETE -- DELETE data rows from a database table UPDATE -- UPDATE data in the database table -- Data

Copy codeCode: drop table data TABLE name (permanently delete a data TABLE) Delete record: delete from table name where condition (rqjs_id = ***) Update all records: update table name set field name = Value Conditional update: update table name set

Common SQL Syntax Functions Code:Functions of Transact SQL statements-- Data OperationsSELECT -- retrieve data rows and columns from database tablesINSERT -- add new data rows to the database tableDELETE -- DELETE data rows from a database

-- Sentence skill -- Data Operations Select -- retrieve data rows and columns from database tables Insert -- add new data rows to the database table Delete -- delete data rows from a database table Update -- update data in the database table -- Data

SQL Statement Collection --statement function --data Operation SELECT--Retrieve data rows and columns from a database table INSERT--Add new data rows to a database table Delete--delete data rows from a database table UPDATE-- Update data in a

Basic knowledge of SQL1. Database query: Select usageSelect [Top (value)] Field list from data table [Where condition] [order BY field] [ASC or DESC] 2. Add data: Insert into usageInsert into Data table (field 1, Field 2, Field 3,...) Values (the