ImDisk 流程設定

  1. 下載並安裝ImDisk、rawcopy
  2. 開啟自動服務「ImDisk Virtual Disk Driver Helper」
  3. 建立虛擬磁碟 imdisk -a -t vm -s 512M -m R: -p "/fs:fat32 /v:MemDisk /q /y"
  4. 控制台 → ImDisk Virtual Disk Driver → 儲存Ramdisk
  5. 本機原則 → 電腦設定 → Windows 設定 → 指令碼 - (啟動/關機)
    • Startup.cmd imdisk -a -t vm -f C:\Ramdisk\Ramdisk.img -m R: Regedit(推薦) Windows Registry Editor Version 5.00

      [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\ImDisk\Parameters]
      "LoadDevices"=dword:00000001
      "FileName0"="\\??\\C:\\Ramdisk\\Ramdisk.img"
      "DriveLetter0"="R"
      "Flag0"=dword:00000200
      "Size0"=hex:00,00,00,20,00,00,00,00
    • Shutdown.cmd RD /S /Q R:\TEMP
      C:\Ramdisk\MyCmdlet\rawcopy.exe -mld \\.\R: C:\Ramdisk\RamDisk.img
      imdisk -D -m R:
  6. Fierfox browser.cache.disk.parent_directory;R:\TEMP

Tools and utilities for Windows
超小巧效能強悍的窮人版 Ramdisk-ImDisk (設定篇) | Kenmingの鮮思維

FETCH

DECLARE @FirstName nvarchar(10),
@City nvarchar(15)
--設定指標
DECLARE tmpCursor CURSOR FAST_FORWARD FOR
SELECT FirstName,City FROM Employees
OPEN tmpCursor --開啟指標
FETCH NEXT FROM tmpCursor INTO @FirstName,@City --設定讀取變數
--迴圈讀取
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @FirstName + ', ' +@City
FETCH NEXT FROM tmpCursor INTO @FirstName,@City
END
CLOSE tmpCursor --關閉指標
DEALLOCATE tmpCursor --移除指標
view raw gistfile1.sql hosted with ❤ by GitHub

FETCH (Transact-SQL)