How to use Parameters option in SQL Query Activity

Permanently deleted user

19. Dezember 2016 08:57

Hi,

 

Can anyone pls tell hos to use the 'parameters' option present in SQLQuery activity in workflow designer. What is its purpose?

 

Thanks :)

 

Srikanth

 

 

0

• 

  Nico Burgerhart

  19. Dezember 2016 09:44

  SQL parameters are values that are added to an SQL query at execution time, in a controlled manner.

   

  Check https://en.wikipedia.org/wiki/Prepared_statement

  0
• 

  Permanently deleted user

  19. Dezember 2016 10:09

  Hi Srikanth,

   

  SQLQuery activity will allow you to access a DataBase and execute a SQL query.

   

  In “Connection” section you can set connection string or reference one that is already set on web.config file.

   

  In “Command” section you can write a SQL query

   

  In “Parameters” section you can specify input/output parameters that you need in your command.

   

  “Result” section is a dataTable object that is going to contain result of SQLQuery

   

   

   

  Please note that parameters in command would need to be written with following syntax

   

  :p_parameter

   

  That in “Parameters” section is going to be set in following way

   

  _img_ alt="User-added image" src="https://latitudegeo--c.na53.content.force.com/servlet/rtaImage?eid=90760000000Cfkw&feoid=Body&refid=0EM600000001QNx" _/_img_

   

  (Please ignore workflow designer validation error in the image: it should not be visible)

   

  I hope this helps

   

  Francesca

  0
• 

  Permanently deleted user

  19. Dezember 2016 10:15

  Thank you very much Nico. That helped a lot.

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.