# Do query functions using getKey=True support MSSQL uniqueidentifier data type? **URL:** \ **Category:** Ignition\ **Tags:** database, scripting\ **Created:** [February 8, 2024, 12:27am UTC](https://forum.inductiveautomation.com/t/do-query-functions-using-getkey-true-support-mssql-uniqueidentifier-data-type/85415 "2024-02-08T00:27:39Z")\ **Posts on this page:** 1\ **Showing post:** 5
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [February 12, 2024, 7:38pm UTC](https://forum.inductiveautomation.com/t/do-query-functions-using-getkey-true-support-mssql-uniqueidentifier-data-type/85415/5 "2024-02-12T19:38:43Z")
So, I managed to nerd-snipe myself. And in the process, added _ **another** _ reason to avoid MS SQL Server like the plague. > [@Automation Professionals' Integration Toolkit Module](https://forum.inductiveautomation.com/t/automation-professionals-integration-toolkit-module/74934/89): > > Automation Professionals is pleased to announce a new release of the Integration Toolkit module. This release adds one new scripting function, [system.db.runPrepInsert()](https://www.automation-pros.com/toolkit/doc/utility.html#runprepinsert). It is very similar to IA's [system.db.runPrepUpdate()](https://docs.inductiveautomation.com/display/DOC81/system.db.runPrepUpdate), intepreting the query, args, database, and tx arguments in the same fashion. The getKey argument is omitted as moot, as this function always retrieves generated keys. The skipAudit optional argument is unimplemented. For Ignition v8.1+: [v2.0.15.240431913](https://www.automation-pros.com/ignition/Integration%20Toolkit-2.0.15.240431913-v81.modl) Do note the docu… --- _[View the full topic](https://forum.inductiveautomation.com/t/do-query-functions-using-getkey-true-support-mssql-uniqueidentifier-data-type/85415)._