110,538
社区成员
发帖
与我相关
我的任务
分享
string sql = "if not exists(select * From master.dbo.sysdatabases where name='GFX_JC ')"
+"CREATE DATABASE GFX_JC ON PRIMARY"
+ "(name=GFX_JC, filename = 'F:\\GFX_JC_DB\\GFX_JC.mdf', size=3,"
+ "maxsize=5, filegrowth=10%)log on"
+ "(name=GFX_JC_log,filename='F:\\GFX_JC_DB\\GFX_JC_log.ldf',size=3,"
+ "maxsize=20,filegrowth=1)";
[/quote]
这个代码具体怎么写呢?在我上面贴的代码中,我试着写了下,好像报错啊!求大神指引啊!
菜鸟刚学习C#
[/quote]
如果使用他的代码,那么就是 string sql = "if not exists(select * From master.dbo.sysdatabases where name='GFX_JC ')"
+"CREATE DATABASE GFX_JC ON PRIMARY"
+ "(name=GFX_JC, filename = 'F:\\GFX_JC_DB\\GFX_JC.mdf', size=3,"
+ "maxsize=5, filegrowth=10%)log on"
+ "(name=GFX_JC_log,filename='F:\\GFX_JC_DB\\GFX_JC_log.ldf',size=3,"
+ "maxsize=20,filegrowth=1)";
[/quote]
sql中可以写判断IF 语句? string sql = "if not exists(select * From master.dbo.sysdatabases where name='GFX_JC ')"
+"CREATE DATABASE GFX_JC ON PRIMARY"
+ "(name=GFX_JC, filename = 'F:\\GFX_JC_DB\\GFX_JC.mdf', size=3,"
+ "maxsize=5, filegrowth=10%)log on"
+ "(name=GFX_JC_log,filename='F:\\GFX_JC_DB\\GFX_JC_log.ldf',size=3,"
+ "maxsize=20,filegrowth=1)";
[/quote]
多谢了!
但是我后面还有建数据表,该写爱哪里呢?
实现的功能是这样的:程序运行时,检查系统内存在数据库不,不存在时,创建数据库,同时创建多个表。如果系统存在数据库,则关闭数据库连接 string sql = "if not exists(select * From master.dbo.sysdatabases where name='GFX_JC ')"
+"CREATE DATABASE GFX_JC ON PRIMARY"
+ "(name=GFX_JC, filename = 'F:\\GFX_JC_DB\\GFX_JC.mdf', size=3,"
+ "maxsize=5, filegrowth=10%)log on"
+ "(name=GFX_JC_log,filename='F:\\GFX_JC_DB\\GFX_JC_log.ldf',size=3,"
+ "maxsize=20,filegrowth=1)";
select * From master.dbo.sysdatabases where name='数据库名'
这句SQL语句会查询指定数据库的详细信息。这样就能查到数据库。