page 205 to page 229.txt

来自「Sql statement it is very cute」· 文本 代码 · 共 28 行

BACKUP DATABASE Sample TO DISK='E:\SQLBackup\Standby.bak'


RESTORE DATABASE Sample FROM DISK='\\DC1\SQLBackup\Standby.bak' 
	WITH STANDBY='C:\SQLStandby\Sampleundo.bak',
	MOVE 'Database' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\data\Database.MDF',
	MOVE 'Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\data\Log.MDF'


RESTORE DATABASE Sample WITH RECOVERY


SELECT * INTO NW_Customers FROM Northwind.dbo.Customers


SELECT * INTO ##NW_Suppliers FROM Northwind.dbo.Suppliers


SELECT * FROM ##NW_Suppliers


INSERT INTO NW_Customers SELECT * FROM Northwind.dbo.Customers


BULK INSERT NW_Produtcts FROM 'E:\NW_Products.txt' WITH (
	DATAFILETYPE = 'widechar',
	FIELDTERMINATOR = '\t',
	ROWTERMINATOR = '\n')