📄 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 + -