INSERT INTO "IBASETL"."T_ZHJF_HX_PER_CISIA"("JFCUNO", "SICUNM", "SIDFNM", "SINTNL", "SISEXX", "SIBRTH", "SIPRFS", "SIAPBG", "SIADDR", "SIZPCD", "SITELP", "SIIDTP", "SIIDNO", "SIISAU", "SICOCD", "SISTC1", "SISTC2", "SISTCD", "ODS_SRC_DT", "SJCPNM", "SJOFAD", "SJOFZP", "SJPSAD", "SJPSZP", "SJHMAD", "SJHMZP", "SJMOBL", "SJADCD", "SJADNM", "SJMDDT", "SJCRDT", "BANK_AGE", "BANK_AGE_UPDATE", "JFBRNO")
VALUES('90001001', 'zxize', NULL, 'CN', '1', '1964-07-08', NULL, NULL, NULL, '954407', NULL, '03', '护照1294293A', NULL, NULL, NULL, NULL, 'A', '2009-12-05', 'a', '', '', '苏州', '215000', '苏州', '215000', '13912609296', '3050', '江苏省苏州市', '2009-06-30', '2007-09-01', 0, NULL, '0110')
GO
INSERT INTO "IBASETL"."T_ZHJF_HX_SCSAA"("SASCNO", "CARDBIN", "SABRNO", "SASBNO", "JFBRNO", "SAACNO", "SACDKD", "SACDID", "JFCUNO", "SACUNO", "SACPNM", "SAICDT", "SAENDT", "SALDDT", "SACSAM", "SANCFG", "SATRDT", "SATRNO", "SAMCFG", "SARCTL", "SAFSFG", "SAMSFG", "SASTCD", "ODS_ORG_ID", "ODS_SRC_DT")
VALUES('9688071500772505', '100000', '00002', '1', '0110', '6288714382911239369', '38', '2', '90001001', '90001001', 'zhao', '2007-09-01', 20970505, 20090111, 5858882308616, '0', '2009-09-30', '67940781174104', '1', NULL, 'A', 'A', 'D', NULL, '2007-09-21')
GO
INSERT INTO "IBASDB"."JG_MEMBER"("M_ID", "DOMAIN_ID", "KIND_ID", "M_CODE", "M_NAME", "M_CODE2", "M_GROUP", "CREATE_TIME", "LAST_UPDATE", "STATUS")
VALUES(91657102, NULL, 19002, '90001001', '未初始化', NULL, NULL, '2009-10-19 10:57:13.0', '2009-10-19 10:57:13.0', '1')
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93731577, 91657102, 90, '90001001.90', 0, 3332, 0, 0, 0, 0, 3332, '1', '2009-10-19 11:22:15.0', '2009-10-19 11:22:19.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93731543, 91657102, 88, '90001001.88', 0, 3332, 0, 0, 0, 0, 3332, '1', '2009-10-19 11:20:10.0', '2009-10-19 11:20:10.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93731502, 91657102, 111, '90001001.85', 0, 1320000, 0, 0, 0, 0, 1320000, '1', '2009-10-19 11:17:20.0', '2009-10-19 11:17:20.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93731136, 91657102, 41, '90001001.41', 0, 10, 0, 0, 0, 0, 10, '1', '2009-10-19 11:02:29.0', '2009-10-19 11:02:30.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93731063, 91657102, 56, '90001001.56', 0, 10, 0, 0, 0, 0, 10, '1', '2009-10-19 10:57:28.0', '2009-10-19 10:57:29.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93731109, 91657102, 43, '90001001.43', 0, 10, 0, 0, 0, 0, 10, '1', '2009-10-19 10:58:38.0', '2009-10-19 10:58:38.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93731083, 91657102, 72, '90001001.72', 0, 10, 0, 0, 0, 0, 10, '1', '2009-10-19 10:57:30.0', '2009-10-19 10:57:30.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93731042, 91657102, 71, '90001001.71', 0, 30, 0, 0, 0, 0, 30, '1', '2009-10-19 10:57:18.0', '2009-10-19 10:57:18.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93731022, 91657102, 54, '90001001.54', 0, 600, 0, 0, 0, 0, 600, '1', '2009-10-19 10:57:15.0', '2009-10-19 10:57:15.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93731002, 91657102, 55, '90001001.55', 0, 10, 0, 0, 0, 0, 10, '1', '2009-10-19 10:57:13.0', '2009-10-19 10:57:14.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93734093, 91657102, 111, '90001001.111', 0, 10, 0, 0, 0, 0, 10, '1', '2009-11-12 10:58:21.0', '2009-11-12 10:58:21.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93734089, 91657102, 118, '90001001.118', 0, 10, 0, 0, 0, 0, 10, '1', '2009-11-12 10:56:03.0', '2009-11-12 10:56:03.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93734077, 91657102, 113, '90001001.113', 0, 10, 0, 0, 0, 0, 10, '1', '2009-11-12 10:55:41.0', '2009-11-12 10:55:41.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93734043, 91657102, 117, '90001001.117', 0, 600, 0, 0, 0, 0, 600, '1', '2009-11-12 10:55:23.0', '2009-11-12 10:55:23.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93734023, 91657102, 116, '90001001.116', 0, 10, 0, 0, 0, 0, 10, '1', '2009-11-12 10:55:22.0', '2009-11-12 10:55:22.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93734002, 91657102, 115, '90001001.115', 0, 30, 0, 0, 0, 0, 30, '1', '2009-11-12 10:54:50.0', '2009-11-12 10:54:50.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93733505, 91657102, 86, '90001001.86', 0, 3332, 0, 0, 0, 0, 3332, '1', '2009-10-19 13:09:24.0', '2009-10-19 13:09:26.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93732300, 91657102, 101, '90001001.101', 0, 60000, 0, 0, 0, 0, 60000, '1', '2009-10-19 11:23:44.0', '2009-10-19 11:23:45.0', 2)
GO
INSERT INTO "IBASDB"."JG_ACCOUNT"("ACCT_ID", "M_ID", "TYPE_ID", "ACCT_CODE", "BEGIN_E", "BASE_E", "AWARD_E", "DEBIT_ADJUST_E", "CREDIT_ADJUST_E", "USE_E", "ACCOUNT_E", "STATUS", "CREATE_TIME", "LAST_UPDATE", "VER")
VALUES(93732503, 91657102, 84, '90001001.84', 0, 33320, 0, 0, 0, 0, 33320, '1', '2009-10-19 13:08:57.0', '2009-10-19 13:09:00.0', 2)
GO
insert into IBASETL.T_ACCT_DEPOIST(JFBRNO,ODS_ACCT_NO,JFCUNO,ODS_SRC_DT,MSOPDT) VALUES ('0110','6288714382911239369','90001001',null,'2010-07-16')
分享到：
相关推荐
在本资源中，我们有一个名为"MySQL官网测试数据上百万条数据sql文件"的压缩包，它包含了一个或多个SQL脚本，这些脚本设计用于在MySQL数据库中创建并填充大量的测试数据。 SQL（Structured Query Language）是用于...
在Oracle数据库管理中，生成大量测试数据是进行性能测试、数据建模以及验证查询效率等场景下不可或缺的一环。本文将深入探讨如何利用一条SQL语句在Oracle中快速生成10万条测试数据，这对于数据库管理员和开发人员来...
6. 测试和调用：在客户端，通过创建DataSnap客户端组件（如TDSClientDataModule）和调用服务方法，可以远程执行服务器上的自定义SQL查询。记得设置好客户端的连接信息，使其能够找到并连接到DataSnap服务器。 7. ...
Java 快速生成 SQL 和模拟数据的网站，大幅提高开发测试效率！by 程序员鱼皮
mysql进行压力测试100万行数据，测试数据库的查询能力。
一直在用的这个工具和大家分享一下，简单易的数据库连接测试工具，主要用来测试是否能连接数据库，不过也可以编码数据库和执行SQL代码，工具虽说，但功能强大。 已测试过 sql server 2000,sql2005,sql2008,mysql, ...
在这个项目中，我们关注的是使用Visual Studio 2005（VS2005）作为开发环境，结合SQL Server 2005作为数据库管理系统构建的会员积分系统。以下将详细讨论这个系统中的关键知识点。 1. **Visual Studio 2005**：VS...
SQL数据生成器是一种工具，主要用于在数据库环境中快速创建和填充大量的测试或示例数据。它对于软件开发、性能测试、数据库设计验证等场景非常有用。通过使用这种工具，用户可以自定义数据规则，生成符合特定业务...
总的来说，LabVIEW结合SQL Server 2005可以通过ODBC接口实现数据的写入操作，这在实验数据记录、自动化测试、设备监控等场景中非常常见。通过熟练掌握这一技能，开发者能够构建出强大的数据处理系统，有效利用数据库...
在这个场景中，它包含了300万条记录，这对于测试数据库性能、查询优化、并发处理能力等提供了充足的数据基础。 1. **数据库性能测试**：百万级别的数据量可以模拟实际生产环境，测试数据库在高负载下的性能。这包括...
根据提供的文件内容，我们可以整理出以下几个SQL面试题及其解答，这些问题主要聚焦于SQL查询...以上问题及解答涵盖了SQL查询的基本语法、子查询的应用、数据处理等多个方面，对于软件测试人员来说具有较高的参考价值。
对于开发人员来说，尤其是需要频繁进行数据查询时，可以快速构建和测试SQL语句，节省了大量的时间。同时，它降低了错误率，因为大多数工具会自动检查语法和逻辑错误，确保生成的SQL语句是有效的。 另外，可视化界面...
在Kettle中，你可以配置H2数据库连接，以便进行数据操作和测试你的动态SQL查询。 至于文件`samples`，这可能包含了Kettle工作流或转换的示例，供你参考和实践。这些示例可能涵盖了如何设置动态SQL查询，以及如何在...
在SQL Server数据库管理中，有时我们需要将表中的数据导出为Insert语句，这在数据迁移、备份或测试环境中非常常见。"SQL Server表数据导出成Insert语句的工具"是一个专门为此目的设计的应用程序，它能帮助数据库管理...
这些数据可以用于构建银行信息查询系统、数据分析项目或是模拟银行操作的测试环境。 - 数据库建模：建表数据意味着包含了创建这些银行信息表的SQL脚本，这通常涉及设计数据库模式，包括主键、外键、索引和约束，...
在“在线SQL查询”这个场景中，ExtJS 被用来构建一个用户界面，允许用户在浏览器中直接执行SQL查询，这对于数据库管理或数据分析来说非常方便。 `Ext.ux.window.VisualSQLQueryBuilder` 是ExtJS的一个扩展组件，...
如何通过Excel来获取SQLServer数据 方便对数据库中的某些数据取数！
标题中的“全世界国家地区名称SQL数据”指的是一个包含全球各国和地区名称的数据集合，它以SQL（结构化查询语言）的形式存在。SQL是用于管理和处理关系数据库的标准编程语言，用于存储、检索、更新和删除数据库中的...
标题中的“最新淘宝商品类目数据.sql”表明这是一个SQL文件，包含了淘宝平台的商品类别数据。在电商领域，商品类目是组织和管理在线销售产品的一种方式，它类似于传统零售店的商品货架，帮助消费者快速找到他们感...
综上，这个项目涉及到MySQL到Elasticsearch的数据同步，通过Quartz或LTS实现定时任务，利用SQL-to-Elasticsearch工具或插件支持SQL查询，并通过Dubbo服务接口对外提供查询服务。在实施过程中，需要关注数据的完整性...