Forum Discussion
How to concat sql query with pipeline parameter?
@concat("SELECT * FROM [dbo].[MyTable] where SourceSystem ='NAV' and NAV_Mandant='W020' and Entry_No_>",activity('LastRecW020NAV').output)
I'm using a german system. Because the where filter also need to be Sting in '' quotation marks it dosn't work.
Is there a alternative text qualifier?
Hi Anonymous ,
One alternative approach is to use double single quotes to escape the single quotes within your string.
Here is the changed codes that you can have a try.
@concat("SELECT * FROM [dbo].[MyTable] where SourceSystem =''NAV'' and NAV_Mandant=''W020'' and Entry_No_>", activity('LastRecW020NAV').output)Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Can you please provide the expected SQL otput statement that you are envisioning to be executed in the database meaning Select * from xyz format.
And also what is your parameter name and a sample value of that.
Using that we would help you make it dynamic? There are 2 ways : 1 using conact and other is direct expression
Hi Anonymous ,
One alternative approach is to use double single quotes to escape the single quotes within your string.
Here is the changed codes that you can have a try.
@concat("SELECT * FROM [dbo].[MyTable] where SourceSystem =''NAV'' and NAV_Mandant=''W020'' and Entry_No_>", activity('LastRecW020NAV').output)Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I am trying to insert the activity error in a table in fabric datawarehouse. But because of special characters like *, ' I am unable to insert that error message into table. Any solution for this?
