2022-12-07 14:23:24 +08:00

24 lines
530 B
Markdown
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

---
title: SQL Server
date: 2022-11-26 14:48:31
author: 文永达
top_img: https://gcore.jsdelivr.net/gh/volantis-x/cdn-wallpaper/abstract/B951AE18-D431-417F-B3FE-A382403FF21B.jpeg
---
# SQL Server
## 建库字符集问题
```sql
ALTER DATABASE ACT_DEV SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE ACT_DEV COLLATE Chinese_PRC_CI_AS;
ALTER DATABASE ACT_DEV SET MULTI_USER;
```
## 精度标度
精度指数字的位数标度指小数点后的位数。例如123.45精度是5标度是2decimal(5, 2)