imr
on --創建數據庫文件
(NAME= ,-- --數據庫文件的額、邏輯名稱
='D:\\.mdf;',--物理名稱,路徑必須存在
size=10, --數據初始長度為10M
=50, --最大長度50M
=5%) --數據文件每次增長5%
LOG on
(
name=,
='D:\\.ldf',
SIZE=1,
=5,
=1;
)
----單擊運行按鈕即可創建數據庫
drop imr;--刪除數據庫
GO
use imr;
table users(
id INT KEY,
names (20),
(20),
email (20)
)
Drop table users;
into users(id,names,,email)(3,'','','');
into users(id,names,,email)(2,'admin','','');
*from users;
names from users;
names from users order by names;
name +'+'+ from