. declare . , . , Transact-SQL .
. . , . , , , .
SQL Server 2000 SQL Server bigint, table sql_variant. :
bigint , 8 ;
float ;
ntext Unicode 1 ;
int , 4 ;
real ;
binary 8000 ;
smallint , 2 ;
datetime (8-);
varbinary 8000 ;
tinyint , 1 ;
smalldatetime (4-);
image 2 ;
bit , 0, 1;
char Unicode 8000 ;
decimal ;
varchar Unicode 8000 ;
timestamp ;
numeric
text Unicode 2 ;
sql_variant , ;
money (8-);
nchar Unicode 4000 ;
smallmoney (4-);
nvarchar Unicode 4000 ;
uniqueidentifier , .
, (user-defined). sysname ( nvarchar(l28)), .
SQL Server 2000 :
- (Integers) bigint, int, smallint tinyint;
- (Decimal) decimal, numeric, float real;
- (Money) money smallmoney;
|
|
- (Date and Time) datetime smalldatetime;
- (Binary) binary, varbinary image;
- (String) char, varchar, nchar nvarchar;
- (Text) text ntext;
- (Specials) timestamp, uniqueidentifier, bit, cursor, table sql variant.
SQL Server 2000
SQL Server 7.0 , Microsoft . . , , . .
, , , , . , , . , , , , ..
SQL Server 2000 . , , . , . table. , . , GetPeople, , , :
SELECT * FROM GetPeople()
, SQL Server 2000. , :
- . . , ;
- . , , ;
- . , . , SQL Server 2000 datetime smalldatetime. , ..;
- . , , ..;
- . SQL Server 2000 ();
|
|
- . , , , ;
- . , , , ..;
- . , , , . , , , ;
- . , , ..;
- image, text ntext.
@@. , . , . . Transact-SQL . .