1> select name from sys.databases;
2> go
name
--------------------------------------------------------------------------------------------------------------------------------
master
tempdb
model
msdb
test
创建表hwtable:
1> create table hwtable ( id int, name varchar(20), gender varchar(20), age int);
2> go
插入数据:
1> insert into hwtable values (1, 'weiheng','male',20);
2> go
查询:
1> select * from hwtable;
2> go
id name gender age
----------- -------------------- -------------------- -----------
1 weiheng male 20
(1 rows affected)
MSSQL Sever On Linux就这样安装完成了!