From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How to make a sql temporary table

Solved!
Go to solution

Hi

I would like to create a temporary sql table - "create table #tempTable...."

but I get error

Is it possible to do it with Labview DB connectivity toolkit?

Thanks...Eran

 

0 Kudos
Message 1 of 3
(2,606 Views)
Solution
Accepted by topic author Eran1965

I know you can create a stored procedure and execute it from within LabVIEW.  And within the stored procedure you can create temp tables.  I like this method because you can easily change the SP code without recompiling your VI.  Hopefully this helps.

aputman
------------------
Heads up! NI has moved LabVIEW to a mandatory SaaS subscription policy, along with a big price increase. Make your voice heard.
Message 2 of 3
(2,573 Views)

yes, This help !!!

0 Kudos
Message 3 of 3
(2,556 Views)