I’m new to TestStand and currently using an SQL Server database to log values. I need help with using INSERT and UPDATE SQL queries in the Open SQL Statement step.
Specifically:
What is the correct format for writing the query in TestStand?
How should I handle inserting DATETIME values so that I don’t run into formatting issues?
Can we make the query parameterized so I don’t have to manually handle string formatting for different data types?
A simple example of what I’m trying to do:
INSERT INTO MyTable (ID, Name, IsActive, CreatedOn, Score) VALUES (101, 'Sample Name', 1, '2025-08-11 14:30:00', 95.75)
If there’s anything else I should consider when logging to SQL Server from TestStand (such as date formats, handling null values, or escaping special characters), I’d appreciate your tips.
Thanks in advance!
