SQL Temp Table Not Working in QC 8.2 DB
In HP QC 8.2, I tried running the following SQL query:
CREATE TABLE #HUH (WHATNOW INT)
INSERT INTO #HUH
SELECT TOP 10 DS_TEST_ID FROM DESSTEPS
SELECT * FROM #HUH
The following error message is returned
Failed to execute the query;
[ServerName]Invalid object name '#HUH'.;
My questions are:
1) Can one create temporary tables within HP QC 8.2?
2) If so, does one use the same query syntax as you would with SQL?
3) Also, if one can create temporary tables, is the capability restricted? Where can one edit the restriction?