alter table tt alter column je decimal(11,4) alter table tt alter column je money
alter table XXX alter column 金额 decimal(11,2)
alter table tb alter column 金额 numeric(18,2)
参照语法和例子 http://technet.microsoft.com/zh-cn/library/ms190273(SQL.90).aspxCREATE TABLE dbo.doc_exy (column_a INT ) ; GO INSERT INTO dbo.doc_exy (column_a) VALUES (10) ; GO ALTER TABLE dbo.doc_exy ALTER COLUMN column_a DECIMAL (5, 2) ; GO DROP TABLE dbo.doc_exy ; GO
alter table tb alter column 金额 numeric(18,2)
http://technet.microsoft.com/zh-cn/library/ms190273(SQL.90).aspxCREATE TABLE dbo.doc_exy (column_a INT ) ;
GO
INSERT INTO dbo.doc_exy (column_a) VALUES (10) ;
GO
ALTER TABLE dbo.doc_exy ALTER COLUMN column_a DECIMAL (5, 2) ;
GO
DROP TABLE dbo.doc_exy ;
GO