人大金仓数据库关于用户创建的问题
久帝-骨头
2024-05-26 21:57:33
最佳回答
应该是size=2mb,不用引号;filegrowth=10%,不用引号use mastergoif ex**ts(select * from sysdatabases where name='news')drop database newscreate database newson(name='news_mdf',filename='d:\db\news.mdf',size=3mb,filegrowth=10%)log on(name='news_log',filename='d:\db\news.log',size=3mb,maxsize=10mb)go
create user salesman2 with password '099105' ;创建超级用户:create user salesmaneger1 with superuser; 20210311