Create table table_name
(column_name data_type [null | not_null] [,])
:
Create _ table tt
(s1 varchar(10) not null,
s2 varchar (20));
drop table tt
,
INSERT
INSERT table_name VALUES (expressions [, n]
VALUES (IDENTITY) times-tamp
:
INSERT authors VALUES(237-55-67,Malow,Gena,)
INSERT authors (tel,fam)
VALUES (244-66-99,Ivanow)
SELECT INTO
.
SELECT {column_name [ AS column_alias], n}
INTO new_table FROM {sourse_table, n} [<select_options>]
column_name , FROM
AS column_alias
INTO new_table
FROM {}
select_options Where, Order by, Grup by ..
SELECT ot AS ,tn,f INTO bd10 FROM bd WHERE ot=200 or ot=100
UPDATE
(table_name WITH {<table_hint_limited> [n]) | view_name |rowset_function_limited}
SET
{colum_name={expression | default | null}
| {([FROM {<table_sourse>} [n] [WHERE <search_condition>]}
| [WHERE CURRENT OF {{[GLOBAL] cursor_name} |cursor_variable_name)]}
[OPTION [<query_hint> [,n])
(table_name WITH {<table_hint_limited> - , .
, . .
view_name
rowset_function_limited
colum_name={expression | default | null , .
FROM {<table_sourse> - .
WHERE <search_condition
WHERE CURRENT OF {{[GLOBAL] cursor_name} |cursor_variable_name)]} .
OPTION [<query_hint> [,n] .
:
UPDATE bd10 SET ot+1, tn=tn-1, f=left(f,1)+. +f WHERE ot=100
tempdb , .
Create Table #CCC (a1 dec(7,2), a2 char(10)) -
Create Table ##CCC (a1 dec(7,2), a2 char(10)) -
_____________________
CHAR, VARCHAR C 1 varchar(30)
BIT, BIT VARYING a1 bit(4)
NUMERIC, DECIMAL (DEC), . a1 dec(7,2)
INTEGER (INT), SMALLINT a1 int(17)
|
|
1 smallint
- 32767
FLOAT, REAL, . 5.2E6
DOUBLE PRECISION .
DATE, TIME, TIMESTAMP / a1 DATE
INTERVAL interval year(2) to month
Interval hour to second(4)
SQL_VARIANT
DECLARE @ _ : DECLARE @a1 int, @a2 int
DECLARE @ Table
( )
Set @a1=Hello, World
Select @a1=Hello, World
Select @a1=MAX(OK) FROM bd SELECT
INSERT INTO @a1 SELECT * FROM i1
INSERT INTO @a1 VALUES () .
--- :
declare @a2 table
(tn int, ot1 int, f char(20))
---
insert int @al
select tn, of, f from bd where ot=200
---
update @al set ot1=222
---
insert into @a2
VALUES (55,22,)
SQL Server, . SQL Server.
@@.....
: @@CONNECTIONS
: @@CPU_BUSY
: @@ROWCOUNT .
. -
, .
,
32 33
20 21
7 8 12 18 22 24 28 31
2 6 9 13 14
1 3 17 23 15
4 5 10 11
25 26 27 29 30
16 19
, -
, , - , , ..
, ,
,
(, : , , ).
CREATE [UNIQUE] INDEX _ ON _
( [[ASC] | DESC] [, [[ASC] | DESC]]...);
: CREATE UNIQUE INDEX tn1 ON i1(tn);
( 1000 )
, ,
- - .
, , - . - ()
- ,
( )
|
|
.
.
, WHERE ORDER BY , .
DROP INDEX .
, , , .