CursorPool
← 返回首页
SQL Server logo

SQL Server

96

SQL Server 开发规则与 Skill,配合 mssql-mcp 访问数据库。

7 条规则

# T-SQL Data Type Guidelines

- Prefer `VARCHAR(n)` over `TEXT`; prefer `NVARCHAR(n)` over `NTEXT`.
- Prefer `DATETIME2` over `DATETIME` for new columns (better precision and range).
- Use `DECIMAL(p,s)` or `NUMERIC(p,s)` for money and financial data; avoid `FLOAT` or `REAL` (imprecise).
- Avoid deprecated types: `IMAGE`, `TEXT`, `NTEXT`.
- Use `VARBINARY(MAX)` instead of `IMAGE` for binary data.
- Specify explicit lengths for `VARCHAR`/`NVARCHAR`; avoid `MAX` unless necessary for large values.