?? page 205 to page 229.txt
字號:
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')
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -