vb里
sqlcmd = "ALTER DATABASE test8" & _
"MODIFY FILE" & _
"(NAME = test8_Data," & _
"MAXSIZE = 600MB) "
Cnn.Execute sqlcmd
ModSqlMaxSize = Err.Description出错 在关键字 'FILE' 附近有语法错误。但在查询分析器执行
ALTER DATABASE test8
MODIFY FILE
(NAME = test8_Data,
MAXSIZE = 600MB)
正确的
请高手赐教
sqlcmd = "ALTER DATABASE test8" & _
"MODIFY FILE" & _
"(NAME = test8_Data," & _
"MAXSIZE = 600MB) "
Cnn.Execute sqlcmd
ModSqlMaxSize = Err.Description出错 在关键字 'FILE' 附近有语法错误。但在查询分析器执行
ALTER DATABASE test8
MODIFY FILE
(NAME = test8_Data,
MAXSIZE = 600MB)
正确的
请高手赐教
"MODIFY FILE" & _
"(NAME = test8_Data," & _
"MAXSIZE = 600MB) "
vb我没有用过,不过你的语句在合成后应该是
"ALTER DATABASE test8MODIFY FILE" & _ rem -----这样就会错了吧,呵呵
"(NAME = test8_Data," & _
"MAXSIZE = 600MB) "