在VB6中分离数据库 [英] Detaching database in VB6

问题描述

所有vb大师向他们问好，我是这里的新手，我只想知道vb6中的代码以分离sql 2000中的数据库以进行.mdf的复制..请帮助！这是为我的学校项目准备的...谢谢您..

hi to all vb masters out their,I''m new here and i just want to know the code in vb6 to detach the database in sql 2000 for metocopy the .mdf.. please help! this is for my school project...thanks in advance..

推荐答案

为什么您的学校在教VB6?它已经过时了将近十年，而且总是垃圾.您应该处理自己的课程，然后尽可能多地忘记VB6，这实际上比不首先了解VB6更好地学习没有VB6的真实语言.

可以通过运行任何其他SQL AFAIK的相同代码来执行分离数据库的SQL.在我使用过的所有语言中都是如此.

Why is your school teaching VB6 ? It''s been obsolete for close to a decade, and was always rubbish. You should deal with your course, then forget as much VB6 as you can, it''s actually better for you to learn real languages without VB6, than to know VB6 first.

The SQL to detach a database can be executed by the same code that runs any other SQL, AFAIK. That''s true in all the languages I''ve used.

这是以下格式:

sp_detach_db [@dbname =]``dbname''
[，[@skipchecks =]''skipchecks'']

和示例:

EXEC sp_detach_db``pubs''，``false''

谁能说，总有一天vb6会像perl一样报仇……

this is the format:

sp_detach_db [ @dbname = ] ''dbname''
[ , [ @skipchecks = ] ''skipchecks'' ]

& an example:

EXEC sp_detach_db ''pubs'', ''false''

who can say, some day vb6 will return with a vengeance in the way perl did...

这篇关于在VB6中分离数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！