⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 invoice.sql

📁 十分好的一个医院管理系统
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
	0,
	0,
	159,
	87310.00,
	43,
	28463.00,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	0,
	5238.60,
	1746.20,
	2549.45,
	996.21,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021220112431',
	3,
	'011298',
	'12-1-2002 0:0:0.000',
	'12-20-2002 11:24:0.000',
	1,
	2,
	1746.20,
	0,
	0,
	159,
	87310.00,
	43,
	28463.00,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	0,
	5238.60,
	1746.20,
	2549.45,
	996.21,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223094147',
	1,
	'011082',
	'4-1-2002 0:0:0.000',
	'12-23-2002 9:41:0.000',
	1,
	1,
	1347.66,
	0,
	0,
	108,
	67383.00,
	11,
	7578.00,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	0,
	4042.98,
	1347.66,
	1967.58,
	265.23,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021223094147',
	2,
	'011082',
	'5-1-2002 0:0:0.000',
	'12-23-2002 9:41:0.000',
	1,
	1,
	1347.66,
	0,
	0,
	108,
	67383.00,
	11,
	7578.00,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	0,
	4042.98,
	1347.66,
	1967.58,
	265.23,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021223094147',
	3,
	'011082',
	'6-1-2002 0:0:0.000',
	'12-23-2002 9:41:0.000',
	1,
	1,
	1347.66,
	150,
	0,
	108,
	67383.00,
	11,
	7578.00,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	0,
	4042.98,
	1347.66,
	1967.58,
	265.23,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021223110201',
	1,
	'018004',
	'10-1-2002 0:0:0.000',
	'12-23-2002 10:59:0.000',
	1,
	1,
	927.84,
	0,
	0,
	20,
	11598.00,
	4,
	1101.60,
	0,
	0,
	6.00,
	2.00,
	2.73,
	3.50,
	695.88,
	0,
	231.96,
	316.63,
	38.56,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223110201',
	2,
	'018004',
	'11-1-2002 0:0:0.000',
	'12-23-2002 10:59:0.000',
	1,
	1,
	927.84,
	0,
	0,
	20,
	11598.00,
	4,
	1101.60,
	0,
	0,
	6.00,
	2.00,
	2.73,
	3.50,
	695.88,
	0,
	231.96,
	316.63,
	38.56,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223110201',
	3,
	'018004',
	'12-1-2002 0:0:0.000',
	'12-23-2002 10:59:0.000',
	1,
	1,
	927.84,
	0,
	0,
	20,
	11598.00,
	4,
	1101.60,
	0,
	0,
	6.00,
	2.00,
	2.73,
	3.50,
	695.88,
	0,
	231.96,
	316.63,
	38.56,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'江龙芳',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223111531',
	1,
	'011291',
	'1-1-2002 0:0:0.000',
	'12-23-2002 11:15:0.000',
	1,
	2,
	1110.84,
	0,
	0,
	86,
	55542.00,
	36,
	29238.00,
	0,
	0,
	6.00,
	2.00,
	3.01,
	3.50,
	0,
	3332.52,
	1110.84,
	1671.81,
	1023.33,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223111531',
	2,
	'011291',
	'2-1-2002 0:0:0.000',
	'12-23-2002 11:15:0.000',
	1,
	2,
	1110.84,
	0,
	0,
	86,
	55542.00,
	36,
	29238.00,
	0,
	0,
	6.00,
	2.00,
	3.01,
	3.50,
	0,
	3332.52,
	1110.84,
	1671.81,
	1023.33,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223111531',
	3,
	'011291',
	'3-1-2002 0:0:0.000',
	'12-23-2002 11:15:0.000',
	1,
	2,
	1110.84,
	240,
	0,
	86,
	55542.00,
	36,
	29238.00,
	0,
	0,
	6.00,
	2.00,
	3.01,
	3.50,
	0,
	3332.52,
	1110.84,
	1671.81,
	1023.33,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223111559',
	1,
	'011291',
	'4-1-2002 0:0:0.000',
	'12-23-2002 11:16:0.000',
	1,
	2,
	1110.84,
	0,
	0,
	86,
	55542.00,
	36,
	29238.00,
	0,
	0,
	6.00,
	2.00,
	3.01,
	3.50,
	0,
	3332.52,
	1110.84,
	1671.81,
	1023.33,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223111559',
	2,
	'011291',
	'5-1-2002 0:0:0.000',
	'12-23-2002 11:16:0.000',
	1,
	2,
	1110.84,
	0,
	0,
	86,
	55542.00,
	36,
	29238.00,
	0,
	0,
	6.00,
	2.00,
	3.01,
	3.50,
	0,
	3332.52,
	1110.84,
	1671.81,
	1023.33,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223111559',
	3,
	'011291',
	'6-1-2002 0:0:0.000',
	'12-23-2002 11:16:0.000',
	1,
	2,
	1110.84,
	0,
	0,
	86,
	55542.00,
	36,
	29238.00,
	0,
	0,
	6.00,
	2.00,
	3.01,
	3.50,
	0,
	3332.52,
	1110.84,
	1671.81,
	1023.33,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223111559',
	4,
	'011291',
	'7-1-2002 0:0:0.000',
	'12-23-2002 11:16:0.000',
	1,
	2,
	1110.84,
	0,
	0,
	86,
	55542.00,
	36,
	29238.00,
	0,
	0,
	6.00,
	2.00,
	3.01,
	3.50,
	0,
	3332.52,
	1110.84,
	1671.81,
	1023.33,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223111559',
	5,
	'011291',
	'8-1-2002 0:0:0.000',
	'12-23-2002 11:16:0.000',
	1,
	2,
	1110.84,
	0,
	0,
	86,
	55542.00,
	36,
	29238.00,
	0,
	0,
	6.00,
	2.00,
	3.01,
	3.50,
	0,
	3332.52,
	1110.84,
	1671.81,
	1023.33,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223111559',
	6,
	'011291',
	'9-1-2002 0:0:0.000',
	'12-23-2002 11:16:0.000',
	1,
	2,
	1110.84,
	150,
	0,
	86,
	55542.00,
	36,
	29238.00,
	0,
	0,
	6.00,
	2.00,
	3.01,
	3.50,
	0,
	3332.52,
	1110.84,
	1671.81,
	1023.33,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223150223',
	1,
	'011082',
	'1-1-2002 0:0:0.000',
	'12-23-2002 15:0:0.000',
	1,
	1,
	1321.82,
	0,
	0,
	106,
	66091.00,
	11,
	7578.00,
	0,
	0,
	6.00,
	2.00,
	2.93,
	3.50,
	0,
	3965.46,
	1321.82,
	1936.47,
	265.23,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'系统管理员',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021223150223',
	2,
	'011082',
	'2-1-2002 0:0:0.000',
	'12-23-2002 15:0:0.000',
	1,
	1,
	1321.82,
	0,
	0,
	106,
	66091.00,
	11,
	7578.00,
	0,
	0,
	6.00,
	2.00,
	2.93,
	3.50,
	0,
	3965.46,
	1321.82,
	1936.47,
	265.23,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'系统管理员',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021223150223',
	3,
	'011082',
	'3-1-2002 0:0:0.000',
	'12-23-2002 15:0:0.000',
	1,
	1,
	1321.82,
	240,
	0,
	106,
	66091.00,
	11,
	7578.00,
	0,
	0,
	6.00,
	2.00,
	2.93,
	3.50,
	0,
	3965.46,
	1321.82,
	1936.47,
	265.23,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'系统管理员',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021223150458',
	1,
	'011082',
	'7-1-2002 0:0:0.000',
	'12-23-2002 15:5:0.000',
	1,
	1,
	1347.66,
	0,
	0,
	108,
	67383.00,
	11,
	7578.00,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	0,
	4042.98,
	1347.66,
	1967.58,
	265.23,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'系统管理员',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021223150458',
	2,
	'011082',
	'8-1-2002 0:0:0.000',
	'12-23-2002 15:5:0.000',
	1,
	1,
	1347.66,
	0,
	0,
	108,
	67383.00,
	11,
	7578.00,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	0,
	4042.98,
	1347.66,
	1967.58,
	265.23,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'系统管理员',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021223150458',
	3,
	'011082',
	'9-1-2002 0:0:0.000',
	'12-23-2002 15:5:0.000',
	1,
	1,
	1347.66,
	60,
	0,
	108,
	67383.00,
	11,
	7578.00,
	0,
	0,
	6.00,
	2.00,
	2.92,
	3.50,
	0,
	4042.98,
	1347.66,
	1967.58,
	265.23,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'系统管理员',
	1,
	'杨良秋',
	'梁碧珍');
INSERT INTO invoice VALUES (
	'021223151052',
	1,
	'011290',
	'1-1-2002 0:0:0.000',
	'12-23-2002 15:10:0.000',
	1,
	2,
	2439.02,
	0,
	0,
	187,
	121951.00,
	40,
	34534.00,
	0,
	0,
	6.00,
	2.00,
	2.96,
	3.50,
	0,
	7317.06,
	2439.02,
	3609.75,
	1208.69,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223151052',
	2,
	'011290',
	'2-1-2002 0:0:0.000',
	'12-23-2002 15:10:0.000',
	1,
	2,
	2439.02,
	0,
	0,
	187,
	121951.00,
	40,
	34534.00,
	0,
	0,
	6.00,
	2.00,
	2.96,
	3.50,
	0,
	7317.06,
	2439.02,
	3609.75,
	1208.69,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223151052',
	3,
	'011290',
	'3-1-2002 0:0:0.000',
	'12-23-2002 15:10:0.000',
	1,
	2,
	2439.02,
	240,
	0,
	187,
	121951.00,
	40,
	34534.00,
	0,
	0,
	6.00,
	2.00,
	2.96,
	3.50,
	0,
	7317.06,
	2439.02,
	3609.75,
	1208.69,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223153010',
	1,
	'011290',
	'4-1-2002 0:0:0.000',
	'12-23-2002 15:29:0.000',
	1,
	2,
	2390.28,
	0,
	0,
	184,
	119514.00,
	43,
	36971.00,
	0,
	0,
	6.00,
	2.00,
	2.95,
	3.50,
	0,
	7170.84,
	2390.28,
	3525.66,
	1293.99,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223153010',
	2,
	'011290',
	'5-1-2002 0:0:0.000',
	'12-23-2002 15:29:0.000',
	1,
	2,
	2390.28,
	0,
	0,
	184,
	119514.00,
	43,
	36971.00,
	0,
	0,
	6.00,
	2.00,
	2.95,
	3.50,
	0,
	7170.84,
	2390.28,
	3525.66,
	1293.99,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223153010',
	3,
	'011290',
	'6-1-2002 0:0:0.000',
	'12-23-2002 15:29:0.000',
	1,
	2,
	2390.28,
	150,
	0,
	184,
	119514.00,
	43,
	36971.00,
	0,
	0,
	6.00,
	2.00,
	2.95,
	3.50,
	0,
	7170.84,
	2390.28,
	3525.66,
	1293.99,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223153145',
	1,
	'011290',
	'7-1-2002 0:0:0.000',
	'12-23-2002 15:31:0.000',
	1,
	2,
	2390.28,
	0,
	0,
	184,
	119514.00,
	43,
	36971.00,
	0,
	0,
	6.00,
	2.00,
	2.95,
	3.50,
	0,
	7170.84,
	2390.28,
	3525.66,
	1293.99,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223153145',
	2,
	'011290',
	'8-1-2002 0:0:0.000',
	'12-23-2002 15:31:0.000',
	1,
	2,
	2390.28,
	0,
	0,
	184,
	119514.00,
	43,
	36971.00,
	0,
	0,
	6.00,
	2.00,
	2.95,
	3.50,
	0,
	7170.84,
	2390.28,
	3525.66,
	1293.99,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223153145',
	3,
	'011290',
	'9-1-2002 0:0:0.000',
	'12-23-2002 15:31:0.000',
	1,
	2,
	2390.28,
	60,
	0,
	184,
	119514.00,
	43,
	36971.00,
	0,
	0,
	6.00,
	2.00,
	2.95,
	3.50,
	0,
	7170.84,
	2390.28,
	3525.66,
	1293.99,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223154630',
	1,
	'014095',
	'1-1-2002 0:0:0.000',
	'12-23-2002 15:46:0.000',
	1,
	1,
	247.62,
	0,
	0,
	27,
	12381.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	2.83,
	3.50,
	0,
	742.86,
	247.62,
	350.38,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223154630',
	2,
	'014095',
	'2-1-2002 0:0:0.000',
	'12-23-2002 15:46:0.000',
	1,
	1,
	247.62,
	0,
	0,
	27,
	12381.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	2.83,
	3.50,
	0,
	742.86,
	247.62,
	350.38,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223154630',
	3,
	'014095',
	'3-1-2002 0:0:0.000',
	'12-23-2002 15:46:0.000',
	1,
	1,
	247.62,
	240,
	0,
	27,
	12381.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	2.83,
	3.50,
	0,
	742.86,
	247.62,
	350.38,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	'温雪琴',
	1,
	'系统管理员',
	'系统管理员');
INSERT INTO invoice VALUES (
	'021223155600',
	1,
	'014095',
	'4-1-2002 0:0:0.000',
	'12-23-2002 15:55:0.000',
	1,
	1,
	247.62,
	0,
	0,
	27,
	12381.00,
	0,
	0,
	0,
	0,
	6.00,
	2.00,
	2.83,
	3.50,
	0,
	742.86,
	247.62,
	350.38,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -