sql server 2000 中的数据类型-优快云博客

本文通过一系列SQL语句示例介绍了不同数据类型的使用方法，包括定义表结构、插入各种格式的数据及基本的表操作等。展示了如何创建临时表、插入特定格式的数据并进行查询与删除。

declare @tmp_table table(tempvalue varchar(100) null)
insert into @tmp_table
select optname from dbo.MSreplication_options
select * from @tmp_table

alter table testTable
(
decimal_field decimal null,
datetime_field datetime null,
money_field money null,
numeric_field numeric null,
binary_field binary null,
sql_variant_field sql_variant null

)
alter table testTable
alter column decimal_field decimal(4,2)

insert into testTable(decimal_field) values(99.999)
insert into testTable(datetime_field) values('12/07/1998')
insert into testTable(datetime_field) values('12/07/1998')
insert into testTable(datetime_field) values(12/07/1998)
insert into testTable(datetime_field) values(12/07/1998)
insert into testTable(money_field) values(99999999999999.12345)
insert into testTable(money_field) values($999999.12345)
insert into testTable(money_field) values(cast('$999,999.12345' as money))
insert into testTable(binary_field) values(0xe)
insert into testTable (sql_variant_field) values('0xe')
insert into testTable (sql_variant_field) values(0xe)
insert into testTable (sql_variant_field) values(123)
insert into testTable (sql_variant_field) values(1234567.123)

select * from testTable
delete from testTable

create table 数字数据
(
decimal_number decimal(8,6),
numeric_number numeric(5,3)
)
insert into 数字数据
values(99.99999788,50)
insert into 数字数据
values(99.999999,300)