imr
on --創(chuàng)建數(shù)據(jù)庫文件
(NAME= ,-- --數(shù)據(jù)庫文件的額、邏輯名稱
='D:\\.mdf;',--物理名稱,路徑必須存在
size=10, --數(shù)據(jù)初始長度為10M
=50, --最大長度50M
=5%) --數(shù)據(jù)文件每次增長5%
LOG on
(
name=,
='D:\\.ldf',
SIZE=1,
=5,
=1;
)
----單擊運(yùn)行按鈕即可創(chuàng)建數(shù)據(jù)庫
drop imr;--刪除數(shù)據(jù)庫
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