object_id (N'...')是什么意思?

这句话是什么意思?if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PerPer

请问:if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PerPersonData]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
中的object_id(N'[dbo].[PerPersonData]')是什么意思?那个object_id函数?那个N?
还有OBJECTPROPERTY(id, N'IsUserTable') = 1中的OBJECTPROPERTY函数是什么意思?那个=1又是什么意思?

OBJECT_ID:返回数据库对象标识号。N是显式的将非unicode字符转成unicode字符,它来自 SQL-92 标准中的 National(Unicode)数据类型,用于扩展和标准化,在这里可以不用,写作object_id(PerPersonData)。

OBJECTPROPERTY:返回当前数据库中对象的有关信息。1表“真”。同样可以写成OBJECTPROPERTY(id, sUserTable) = 1。


整条语句的意思是判断数据库里有没有存在PerPersonData这样一张表。


整条语句可以简写成:
if exists (select * from sysobjects where objectproperty(object_id('PerPersonData'),'istable') = 1)

我可以帮你将这段 SQL 转换成 Ignite 的写法,以下是转换后的代码: ```java IgniteCache<Object, Object> cache = ignite.getOrCreateCache("myCache"); SqlFieldsQuery query = new SqlFieldsQuery( "WITH t AS (" + " SELECT NVL(t2.FINANCIER, t2.ISSUER) customerId, " + " NVL(NVL(t1.TDY_FLOAT_INGPL, 0) + NVL(t1.DSC_COST_AMT, 0), 0) AS amount " + " FROM PTL_SEC_VALUTION t1 " + " INNER JOIN FIN_PRODUCT t2 ON t1.FINPROD_ID = t2.FINPROD_ID " + " INNER JOIN FIN_PRODUCT_TYPE t3 ON t3.FINPROD_ID = t2.FINPROD_ID " + " WHERE (t2.FINPROD_TYPE2 = 'F01' " + " OR (t2.FINPROD_TYPE2 = 'F18' AND t3.TYPE_6 = 'P01' AND t3.TYPE_7 = '1209') " + " OR (t2.FINPROD_TYPE2 = 'F18' AND t3.TYPE_6 = 'P11')) " + " AND t1.CDATE = to_date(?, 'yyyy-MM-dd') - 1" + ") " + "SELECT h.counterId " + "FROM (" + " SELECT n.counterId, n.amount " + " FROM (" + " SELECT m.counterId, sum(amount) amount " + " FROM (" + " SELECT t5.customer_Id counterId, T.AMOUNT " + " FROM t " + " INNER JOIN MST_CUSTOMER_INFO_ADD t5 ON t5.customer_id = t.customerId " + " WHERE t5.INDUSTRY != '10' AND t5.PARENT_CUSTOMER_ID IS NULL " + " UNION ALL " + " SELECT t6.customer_Id counterId, T.AMOUNT " + " FROM t " + " INNER JOIN MST_CUSTOMER_INFO_ADD t5 ON t5.customer_id = t.customerId " + " INNER JOIN MST_CUSTOMER_INFO_ADD t6 ON t6.customer_id = t5.PARENT_CUSTOMER_ID " + " WHERE t5.INDUSTRY != '10'" + " ) m " + " GROUP BY m.counterId " + " ) n " + " ORDER BY n.amount DESC" + ") h " + "WHERE ROWNUM < 11" ); query.setArgs(valDate); try (QueryCursor<List<?>> cursor = cache.query(query)) { for (List<?> row : cursor) { Object counterId = row.get(0); // Do something with the counterId } } ``` 在上面的代码中,我们首先获取了一个 Ignite Cache 对象,然后创建了一个 `SqlFieldsQuery` 对象,将原来的 SQL 语句作为参数传递进去,并使用 `setArgs` 方法设置 SQL 语句中的参数值。最后,我们使用 `cache.query` 方法执行查询,并遍历结果集中的每一行数据,在其中获取 `counterId` 并做一些处理。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值