创建了数据库Company,还有表employee。。
CREATE DATABASE Company
ON
( NAME = Company_dat,
FILENAME = 'd:\data\Company.mdf',
SIZE = 1MB,
MAXSIZE = 5MB,
FILEGROWTH = 5MB )
LOG ON
( NAME = 'Company_log',
FILENAME = 'd:\data\Company.ldf',
SIZE = 1MB,
MAXSIZE = 5MB,
FILEGROWTH = 1MB )
CREATE TABLE employee
(
ID int not null,
name varchar(20) not null,
sex char(2) null,
birthday datetime null,
salary money null,
)现在要修改employee表中的字段salary数据类型为numeric(9,2);请问这一步怎么编写啊?
CREATE DATABASE Company
ON
( NAME = Company_dat,
FILENAME = 'd:\data\Company.mdf',
SIZE = 1MB,
MAXSIZE = 5MB,
FILEGROWTH = 5MB )
LOG ON
( NAME = 'Company_log',
FILENAME = 'd:\data\Company.ldf',
SIZE = 1MB,
MAXSIZE = 5MB,
FILEGROWTH = 1MB )
CREATE TABLE employee
(
ID int not null,
name varchar(20) not null,
sex char(2) null,
birthday datetime null,
salary money null,
)现在要修改employee表中的字段salary数据类型为numeric(9,2);请问这一步怎么编写啊?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货