MSSQL

• T-SQL - Transact-SQL

port	for
1433	default
1434	browser service

nmap -p 1433,1434 HOST

-- 服务器信息
SELECT @@VERSION;

SELECT SERVERPROPERTY('ProductVersion')      AS ProductVersion,      -- e.g., 15.0.2112.4
       SERVERPROPERTY('ProductLevel')        AS ProductLevel,        -- e.g., RTM, SP1, SP2
       SERVERPROPERTY('ProductMajorVersion') AS ProductMajorVersion, -- e.g., 15 (for SQL 2019)
       SERVERPROPERTY('Edition')             AS Edition -- e.g., Developer Edition, Standard Edition
;


SELECT TOP 3 * FROM Users;

sql	mssql
limit	top

备份

• .bkf
• ntbackup 工具
• geocar/mtftar
  • .bkf -> tar

Windows NTbackup archive NT, with file catalog, soft size 1*512, software (0x1200): Microsoft SQL Server

导出

bcp "SELECT * FROM database.schema.table" queryout "output.csv" -c -t, -S servername -U username -P password

Invoke-Sqlcmd -Query "SELECT * FROM database.schema.table" -ServerInstance "servername" | Export-Csv -Path "output.csv" -NoTypeInformation