# \#dbquery

**URL:** https://community.cdata.com/tag/dbquery/779.md

[Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md)

---

## [dbQuery with multiple statements](https://community.cdata.com/t/dbquery-with-multiple-statements/1247)

<div class="topic-metadata">

**Author:** [@Travis](https://community.cdata.com/u/Travis)\
**Replies:** 1\
**Last updated:** [December 24, 2025, 12:16pm UTC](https://community.cdata.com/t/dbquery-with-multiple-statements/1247 "2025-12-24T12:16:48Z")

</div>

How can I get this Sql Server dbQuery to work? The INSERT is completing fine, but I need to get the inserted identity PK and Arc is not picking it up. \<arc:set attr="db.query"\> insert into table (...) values (...); se…

---

## [dbQuery check for null results](https://community.cdata.com/t/dbquery-check-for-null-results/1190)

<div class="topic-metadata">

**Author:** [@Travis](https://community.cdata.com/u/Travis)\
**Replies:** 1\
**Last updated:** [September 16, 2025, 9:28am UTC](https://community.cdata.com/t/dbquery-check-for-null-results/1190 "2025-09-16T09:28:59Z")

</div>

Is there a better way to check for null results from a dbQuery, I feel dirty for coming up with this: \<arc:set attr="db.query"\>select null as something;\</arc:set\>\<arc:call op="dbQuery" in="db" out="results"\> \<arc:if …
