【vfp开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了vfp开源代码-createdatabasewithsql.prg的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
LOCAL nHandle,cSQl,nResult
nHandle=SQLSTRINGCONNECT("Driver=SQL Server;Server=CCB-ZHJ;UID=sa;PWD=;Database=Master")
IF nHandle<0
=MESSAGEBOX("无法建立连接!")
RETURN
ENDIF
cSQL="CREATE DATABASE MyDb "+;
"ON "+;
"( NAME=MyDb_dat,"+;
"FILENAME='C:\Program Files\Microsoft SQL Server\MSSQL\Data\MyDbdat.mdf',"+; &&请注意该路径必须有效
"SIZE = 10,"+;
"MAXSIZE = 50,"+;
"FILEGROWTH = 5 )"+;
"LOG ON "+;
"( NAME = 'MyDb_log',"+;
"FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\MyDblog.ldf',"+;
"SIZE = 5MB,"+;
"MAXSIZE = 25MB,"+;
"FILEGROWTH = 5MB )"
nResult=SQLEXEC(nHandle,cSQL)
IF nResult<0
=MESSAGEBOX("无法建立数据库!")
ELSE
=MESSAGEBOX("建立数据库成功!")
ENDIF
=SQLDISCONNECT(nHandle) &&断开连接
上一篇:
createdatabasewithdmo.prg
下一篇:
关于大学英语教学