Data-SQL Server.


Follow the Step to Query and Get data into Collection.

Step-1 Connect you SQL Server.



Step-2 Create database with the help of below command in query window.



Step-3 Create a table with the help of below screenshot..



Step-4 Insert into table with this command



Step-5 Check the created table with this command



Step-6 Create a SP with the help of below screenshot.



Step-7 Execute SP with this command.



Step-8 Set Connection with the help of action stage, here you need to pass input parameter as server name (You will see the server at the time of connecting sql- please refer step1 for the same) and Database name(Whatever database you will create).



Data from Select Query of SQL.

Step-9 Now use another action stage to get the data from database with the help of Get Collection and write the SQL select command to fetch the data from database.



Data from Strore procedure of SQL.

Step-10 Now use same action stage(Get Collection) to get the data from database with the help of Get Collection and write the Collection with execute store procedure .