sql server 2005 express 怎样输入数据

要么用企业管理器打开直接输入,当然注意主键、外键的约束，这个简单，没什么好讲的
要么打开查询分析器，输入代码。我举个例子吧，学生成绩管理的，你直接把这代码复制到查询分析栏里运行就好：
CREATE DATABASE Test
go
use Test
go
CREATE TABLE S
(Sno CHAR(8) Primary key,
Sname CHAR(6) not null UNIQUE,
Ssex CHAR(2) not null check(Ssex='男' or Ssex='女'),
Sbirthday DATETIME check(Sbirthday<='1990-12-31'),
Sdept CHAR(10) DEFAULT '信科系',
Sgrade INT check(Sgrade>=1 and Sgrade<=4)
);
CREATE TABLE C
(Cno CHAR(4) PRIMARY KEY,
Cname CHAR(10) not null UNIQUE,
Ccredit INT Check(Ccredit>=1 and Ccredit<=6)
);
CREATE TABLE SC
(Sno CHAR(8),
Cno CHAR(4),
SCscore INT check(Scscore>=0 and Scscore<=100),
Primary key (Sno, Cno),
foreign key (Sno) references S(Sno),
foreign key (Cno) references C(Cno)
);
Insert into S(Sno,Sname,Ssex,Sbirthday,Sdept,Sgrade)
values('95001','