I have passed the variable (in_DBSchema_Table_Name) dynamically and getting below error
“INSERT Into “+in_DBSchema_Table_Name+” ([DocNo],[Version],[Title],[Language],[FileName],[FileDownloadedDate],[BotStatus],[BotComments]) VALUES (@DocNo,@Version,@Title,@Language,@FileName,@FileDownloadedDate,@BotStatus,@BotComments)”
Error :
It works when i hardcode the schema & table name .
Below is the working query :
“INSERT Into [SVC_Test].[dbo].[HMN_CSR__PERFORMANCE_TRACKER] ([DocNo],[Version],[Title],[Language],[FileName],[FileDownloadedDate],[BotStatus],[BotComments]) VALUES (@DocNo,@Version,@Title,@Language,@FileName,@FileDownloadedDate,@BotStatus,@BotComments)”