:::tip{title="SQL"}
查询sql数据库中表占用的空间大小

:::




```
SELECT
t.NAME AS '表名称',
s.Name AS '架构',
p.rows AS '数据条数',
SUM(a.total_pages) * 8 AS '总分配空间KB',
CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS '总分配空间MB',
SUM(a.used_pages) * 8 AS '数据使用空间KB',
CAST(ROUND(((SUM(a.used_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS '数据使用空间MB',
(SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS '未使用空间KB',
CAST(ROUND(((SUM(a.total_pages) - SUM(a.used_pages)) * 8) / 1024.00, 2) AS NUMERIC(36, 2)) AS '未使用空间MB'
,t.modify_date  最后修改时间
FROM
sys.tables t
INNER JOIN 
sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN 
sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN 
sys.allocation_units a ON p.partition_id = a.container_id
LEFT OUTER JOIN 
sys.schemas s ON t.schema_id = s.schema_id
WHERE
t.NAME NOT LIKE 'dt%' AND t.is_ms_shipped = 0 AND i.OBJECT_ID > 255
GROUP BY 
t.Name 
,s.Name
,p.Rows
,t.modify_date
ORDER BY 
CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) DESC
```

查询sql数据库中表占用的空间大小

:::tip{title="打印错误"}
创建 PrintServer对象时发生异常。Win32误:RPC服务器不可用。

:::




![image.png](/static/img/b7aeb804ddabec3946eb00928343afbd.image.webp)

回答：这个是打印服务停止了，按一下操作试下
1、重启电脑

2、系统服务---print spooler 启动即可


![image.png](/static/img/db4ca7244d12fe1c7af08c8dcbe8316a.image.webp)

创建 PrintServer对象时发生异常。Win32误:RPC服务器不可用。

:::tip{title="条码打印"}
条码打印：路径的形式不合法。
:::





![image.png](/static/img/c0be9e3e71fb8d0bc8dff9b837f61d8c.image.webp)
或者打印时候，提示选择文件

![image.png](/static/img/a17ff6e6e69111c1192621ef85a10d05.image.webp)


>回答：这个是不知道BarTender 的安装目录了。手工选择一下即可
默认路径：
c:\Program Files (x86)\Seagull\BarTender Suite\bartend.exe

![d9245ec0419faf44fc941b0e4b3dfe3.png](/static/img/924163bbedca662715d16eef8672e56a.d9245ec0419faf44fc941b0e4b3dfe3.webp)

条码打印：路径的形式不合法。

:::tip{title="打印报错"}
安卓手机：云POS打印报错：打印失败，JSON error
（使用蓝牙打印机）
:::




![image.png](/static/img/ac57f7669199e303ce2af771f933afa1.image.webp)

![image.png](/static/img/7d8540d4f1a256ac9f55e2948e664291.image.webp)

蓝牙打印机：

![image.png](/static/img/7eaf295691adcfcfa47eba078f5bdbcd.image.webp)

> 此问题是APP的版本问题，建议安装 V1.9.8的版本 ([下载链接](http://ys.hanson.cn:5555/apk/%E6%98%93%E7%A5%9E%E4%BA%91POS.apk))

建议58mm蓝牙打印机：佳博(Gprinter) GP-58MBIII+ 58mm 热敏小票打印机 手机蓝牙版 

https://item.jd.com/100008951939.html


![image.png](/static/img/bdd44318946d3c93f43efd602b034343.image.webp)





![image.png](/static/img/0459f8582c8693275aa3ec47ff9cb4fd.image.webp)

云POS打印报错：打印失败，JSON error

:::tip{title="登用户"}
用户名如何更改

:::




![image.png](/static/img/8d09654339f68d3a2bcd78d6b5634adc.image.webp)

>后台系统：用户资料--用户名改名


![b760cfa4d45da637735b82710037747.png](/static/img/0a837515ab563a244bfed63ba3947df3.b760cfa4d45da637735b82710037747.webp)