sql #4972
Unanswered
PrabhakaranTankaey
asked this question in
Q&A
sql
#4972
Replies: 1 comment 1 reply
-
Do you get any errors? Does it work if you break the statement into two calls? (See below) Also what is the value or content of
|
Beta Was this translation helpful? Give feedback.
1 reply
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hi
I try to create global temp table in sql from mirth javascript.but it not work simultaneously
first time it works and next time it not
This is my code:
try {
var CreateQuery=DROP TABLE IF EXISTS ##testing_8209; CREATE TABLE ##testing_8209(AccountNumber nvarchar (2000) Null,AccountNumberone nvarchar (2000) Null)
var dbConn = DatabaseConnectionFactory.createDatabaseConnection('com.microsoft.sqlserver.jdbc.SQLServerDriver',DbInsatnce,DbUser,DbPassword);
var result = dbConn.executeCachedQuery(CreateQuery);
dbConn.close();
}
catch(e)
{
logger.info('CreateGlobalTempTable ='+ e.message);
return e.message;
}
Beta Was this translation helpful? Give feedback.
All reactions