sql server 2000 ÖеÄÊý¾ÝÀàÐÍ

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)