To determine which version of SQL Server 2000 is running, connect to SQL Server 2000 by using Query Analyzer, and then run the following code:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
The results are:
The product version (for example, 8.00.534).
The product level (for example, "RTM" or "SP2").
The edition (for example, "Standard Edition").
SQL BASICS
SQL SELECT Syntax
SELECT (columnlist)
FROM (tablename)
SQL WHERE Clause Syntax
(
WHERE (conditions)
SQL INSERT Syntax
INSERT INTO
VALUES ((value_list))
SQL UPDATE Syntax
UPDATE
SET (column_name) = (column_value)
WHERE (where_conditions)
SQL DELETE Syntax
DELETE FROM (table_name)
WHERE (where_conditions)
SQL ADMINISTRATION
CREATE DATABASE (database_name)
DROP DATABASE (database_name)
CREATE TABLE (table_name) ( (column_name1) (datatype1) (constraint1) (column_name2) (datatype2) (constraint2) (constraint-list) )
SQL ALTER TABLE Syntax
ALTER TABLE (table_name) ADD (column_name1) (datatype1) (constraint1)
ALTER TABLE (table_name)
ALTER COLUMN (column_name1) (datatype1) (constraint1)
ALTER TABLE (table_name) DROP COLUMN (column_name1) (datatype1)
DROP (table_name) ( (column_list)
CREATE INDEX (index_type) (index_name) ON (table_name) ((column_name1) (index_order),(column_name2) (index_order),)
CREATE UNIQUE INDEX (index_type) (index_name) ON (table_name) ((column_name1) (index_order),(column_name2) (index_order),)
ADD (constraint_name)
FOREIGN KEY ((column_name1) ,(column_name2) )
REFERENCES (table_name)((column_name1) ,(column_name2))
DROP FOREIGN KEY (foreignkey_name)
DROP VIEW (view_name>.)
SQL ADVANCED
(value_1) + (value_2)
SELECT SUBSTRING((column_name), position, length)
FROM (table_name)
SELECT LTRIM((value_1))
SELECT RTRIM((value_1))
SELECT (column_list)
FROM (table_name)
WHERE (condition_1)
ANDOR (condition_2)
SELECT (column_list)
FROM (table_name)
WHERE (column_name IN (value_list))
SELECT (column_list)
FROM (table_name)
WHERE (column_name) BETWEEN (lower_value) AND (higher_value)
SELECT (column_list)
FROM (table_name)
WHERE (column_name) LIKE (like_condition)
The (like_condition) supports the following patterns: 'ABC%' - where a string begins with the letters 'ABC' '%XYZ' - where a string ends with the 'XYZ' '%TUV%' - where the string contais 'TUV' anywhere
SELECT DISTINCT (column_name)FROM (table_name)
SELECT (column_name1), (column_name2) (aggregate_function)
FROM (table_name)
GROUP BY (column_name1), (column_name2)
SQL Aggregate Functions Syntax
SELECT (column_name1), (column_name2) (aggregate_function(s))
FROM (table_name)
GROUP BY (column_name1), (column_name2)
The functions include: count() - counts a number of rows sum() - compute sum avg() - compute average min() - compute minimum max() - compute maximum
SELECT (column_name1), (column_name2) (aggregate_function)
FROM (table_name)
GROUP BY (column_name1), (column_name2)
HAVING (having_condition) The (having_condition)
may include Aggregate Function(s).
SELECT (column_name1), (column_name2) FROM (table_name)
ORDER BY (column_name1)[ASCDESC], (column_name2)[ASCDESC]
Multiple columns can be included in the ORDER BY clause. The direction of the sort is controlled by: ASC - ascending sequence DESC - descending sequence
SELECT (column_name1), (column_name2) (aggregate_function)
FROM (table_name)
JOIN (table_name) ON (join_conditions)
SELECT (column_name1), (column_name2) (aggregate_function)
FROM (table_name)
LEFT OUTER JOIN (table_name) ON (join_conditions)
Tiada ulasan:
Catat Ulasan