IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'book03')
EXEC sp_detach_db 'book03', 'true'
GO
EXEC sp_attach_db @dbname = N'book03',
@filename1 = N'C:\Program Files\ASPNET_BOOK\ASPNET_BOOK\database\book03.mdf',
@filename2 = N'C:\Program Files\ASPNET_BOOK\ASPNET_BOOK\database\book03_log.LDF'
GO
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'book08')
EXEC sp_detach_db 'book08', 'true'
GO
EXEC sp_attach_db @dbname = N'book08',
@filename1 = N'C:\Program Files\ASPNET_BOOK\ASPNET_BOOK\database\book08.mdf',
@filename2 = N'C:\Program Files\ASPNET_BOOK\ASPNET_BOOK\database\book08_log.LDF'
GO
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'book09')
EXEC sp_detach_db 'book09', 'true'
GO
EXEC sp_attach_db @dbname = N'book09',
@filename1 = N'C:\Program Files\ASPNET_BOOK\ASPNET_BOOK\database\book09_Data.MDF',
@filename2 = N'C:\Program Files\ASPNET_BOOK\ASPNET_BOOK\database\book09_Log.LDF'
GO
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'book10')
EXEC sp_detach_db 'book10', 'true'
GO
EXEC sp_attach_db @dbname = N'book10',
@filename1 = N'C:\Program Files\ASPNET_BOOK\ASPNET_BOOK\database\book10.mdf',
@filename2 = N'C:\Program Files\ASPNET_BOOK\ASPNET_BOOK\database\book10_log.LDF'
GO
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'book12')
EXEC sp_detach_db 'book12', 'true'
GO
EXEC sp_attach_db @dbname = N'book12',
@filename1 = N'C:\Program Files\ASPNET_BOOK\ASPNET_BOOK\database\book12_Data.MDF',
@filename2 = N'C:\Program Files\ASPNET_BOOK\ASPNET_BOOK\database\book12_log.LDF'
GO
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'bookdata')
EXEC sp_detach_db 'bookdata', 'true'
GO
EXEC sp_attach_db @dbname = N'bookdata',
@filename1 = N'C:\Program Files\ASPNET_BOOK\ASPNET_BOOK\database\bookdata.mdf',
@filename2 = N'C:\Program Files\ASPNET_BOOK\ASPNET_BOOK\database\bookdata_log.LDF'
GO
评论6
最新资源