# odbc - insert/update sql server tables from q

**URL:** https://forum.kx.com/t/odbc-insert-update-sql-server-tables-from-q/8602
**Category:** Community Support
**Tags:** kdb-and-q
**Created:** [January 29, 2014, 4:33am UTC](https://forum.kx.com/t/odbc-insert-update-sql-server-tables-from-q/8602 "2014-01-29T04:33:00Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![Billy1](https://avatars.discourse-cdn.com/v4/letter/b/c37758/32.png) [@Billy1](https://forum.kx.com/u/Billy1)
#### Post date: [January 29, 2014, 4:33am UTC](https://forum.kx.com/t/odbc-insert-update-sql-server-tables-from-q/8602/1 "2014-01-29T04:33:00Z")

</div>

Hello,

I am using odbc to connect to MS SQL Server.&nbsp;

I am able to read tables, but after I perform some updates, say insert some new rows into the table, I’d like to send them back to SQL Server.&nbsp;

I am wondering if there is a way to do that in odbc.k, NOT through the evaluation of INSERT statements, since there can be hundreds or thousands of new rows.&nbsp;

Thank you!

Bill