微软 SQL Server 命令行工具包
微软 SQL Server 命令行工具包
Command-line tool for managing Microsoft SQL Server databases
Command-line toolkit for Microsoft SQL Server.
直接复制以下提示词,发送给你的 AI 助手即可完成安装。
# SQL Server Toolkit
Command-line toolkit for Microsoft SQL Server.
## Capabilities
- Schema creation
- Versioned migrations
- Index management
- Performance diagnostics
- Backup & restore
- Bulk import/export
## Connect
sqlcmd -S localhost -E
sqlcmd -S localhost -U sa -P YourPassword
## Run Script
sqlcmd -S localhost -d MyDatabase -i script.sql
## Example Table
CREATE TABLE Users (
Id INT IDENTITY(1,1) PRIMARY KEY,
Email NVARCHAR(255) NOT NULL UNIQUE,
Name NVARCHAR(100) NOT NULL,
CreatedAt DATETIME2 DEFAULT SYSDATETIME()
);
## Example Index
CREATE INDEX IX_Users_Email ON Users(Email);
## Backup Example
BACKUP DATABASE MyDatabase
TO DISK = 'C:\backup\MyDatabase.bak'
WITH FORMAT, INIT;
## Performance Diagnostics
SET STATISTICS IO ON;
SET STATISTICS TIME ON;
文件内容直接读取自技能仓库,仅供安装前审阅;以实际下载的压缩包为准。