|
|
|
| The statistical analysis of using Microsoft SQL Server stored procedure to making hospital business statements and reports |
| Xu Zejie1, Ding Zang2 |
1 Department of Statistic, GuangDong Second Traditional Chinese Medicine Hospital, Guangzhou 510095, China;
2 Shenzhen Baoan District Central Hospital |
|
|
|
|
Abstract Objective Propose the methods of statistics to analysis hospital business quickly and exactly, provide the evidence for decision-making of hospital management. Methods For making difference statistical reports and write difference SQL stored procedure statements. Results Query and export statistical reports according to custom fields and data formats. Conclusion Writing custom stored procedure statements can help to improve timeliness and accuracy for making statistical analysis.
|
|
Received: 13 October 2017
|
|
|
|
[1] 王珊,萨师煊.数据库系统概论[M].北京:高等教育出版社,2006.
[2] 刘冬生,欧阳菊香,王尔笑,等. 基于SQL的重点疾病和重点手术查询统计[J].中国卫生统计,2015,32(5):863-864.
[3] 王玮.试探用T-SQL语言创建传染病统计报表[J].安徽预防医学杂志,2015,21(1):17-20.
[4] 顾晓鸣.临床路径实施工作中统计室报表制作过程[J].中国医院统计,2014,21(1):76-78.
[5] 顾晓鸣.运用Select编写锁定、警示语句审核病案首页信息[J].中国医院统计,2008,15(2):117-120.
[6] 周琴.掌握SQL查询提高统计效率[J].中国医院统计,2008,15(2):100-101.
[7] 盖红卫,王海龙,赵莉.基于医院信息平台的电子病案信息SQL查询[J].中国医院统计,2016,23(2):96-99.
[8] 刘国柱,杨振宇,殷堰.SQL Select语句在医院统计查询中的应用实例[J].中国医院统计,2010,17(1):88-91.
[9] 胡凯,刘丽华,徐勇勇,等.医院动态统计数据的静态转储[J].中国医院统计,2001,8(1):8-10.
[10]喻玫.SQL Server查询语句在统计病案程序中的应用[J].中国医院统计,2008,15(1):94-96.
[11]高丽娟,宁亚宁,孙大军,等. 增加“军卫一号”数据核查条件对病案首页信息进行监控[J].中国医院统计,2009,16(4):324-327.
|
| [1] |
Peng Weibin, Liu Yan, Wu Youchun, Mei Jing, Liu Qiong. Statistical analysis of disease spectrum of death cases in a hospital from 2003 to 2016[J]. journal1, 2017, 24(4): 241-244. |
| [2] |
. [J]. journal1, 2017, 24(4): 312-315. |
| [3] |
. [J]. journal1, 2017, 24(3): 231-233. |
| [4] |
. [J]. journal1, 2017, 24(2): 157-158. |
| [5] |
. [J]. journal1, 2017, 24(2): 132-135. |
| [6] |
. [J]. journal1, 2017, 24(2): 159-160. |
|
|
|
|
