Recent questions tagged sql - Knowledge Base

0 votes

1 answer 183 views

how do i convert a qie date value to pass to sql server query

asked May 20, 2021 by nickie-l-1757 (200 points)

0 votes

1 answer 175 views

How to read DB table value and create an XML using custom logic?

asked Apr 28, 2021 by deepthi-a-5184 (240 points)

0 votes

1 answer 116 views

Can I include some sort of debug info in an SQL query?

asked Apr 27, 2021 by rich-c-2789 (16,020 points)

0 votes

1 answer 327 views

What is the most common SQL comment syntax?

asked Apr 27, 2021 by rich-c-2789 (16,020 points)

0 votes

1 answer 339 views

What is the syntax for the Database Update SQL Stmnt to reference the query results?

asked Apr 14, 2020 by brandon-w-8204 (31,870 points)

0 votes

2 answers 428 views

Can a parameterized query implement output parameters for a stored procedure?

asked Mar 31, 2020 by lewis-s-9714 (1,020 points)

+1 vote

1 answer 5.0K views

When calling a stored procedure should I use execute, executeUpdate, executeQuery, or executeBatch?

asked Jul 23, 2019 by rich-c-2789 (16,020 points)

0 votes

3 answers 7.0K views

What is the difference between the CALL keyword and the EXEC keyword to call a stored procedure?

asked Jul 22, 2019 by rich-c-2789 (16,020 points)

0 votes

1 answer 538 views

Query From DB and Write to File

asked Apr 11, 2019 by michael-s-4691 (220 points)

0 votes

1 answer 344 views

Need to Update Database in Destination Node using getNode

asked Mar 21, 2019 by gene-p-5146 (120 points)

0 votes

1 answer 365 views

Can you please send me the channel also?

asked Feb 25, 2019 by martin-g-6661 (120 points)

0 votes

1 answer 382 views

GUI to do mapping

asked Nov 29, 2018 by (270 points)

0 votes

1 answer 981 views

How to create an ADT HL7 from a DBQuery

asked Sep 6, 2018 by david-m-4997 (120 points)

0 votes

3 answers 588 views

Create a CSV based off of a query

asked Apr 5, 2018 by maria-j-3133 (200 points)

0 votes

1 answer 444 views

How can I read data from a CLOB field.

asked Feb 15, 2018 by rich-c-2789 (16,020 points)

0 votes

1 answer 393 views

What SQL wildcards are available in doQuery with the LIKE operator?

asked Oct 26, 2017 by rich-c-2789 (16,020 points)

0 votes

2 answers 454 views

SQL Query from HL7 fields

asked Jun 14, 2017 by cliff-s-2873 (240 points)

+1 vote

1 answer 832 views

How to insert nulls using a parameterized query

asked Dec 5, 2016 by rich-c-2789 (16,020 points)

0 votes

2 answers 550 views

How to insert binary data using a parameterized query

asked Dec 5, 2016 by rich-c-2789 (16,020 points)

0 votes

1 answer 998 views

How to convert a 'Standard Query' to a 'Parameterized Query'?

asked Dec 3, 2016 by rich-c-2789 (16,020 points)