Skip to main content
Question

How to retrieve a database record count and save it to a variable

E
Forum|alt.badge.img+3

Is it possible to return a database record count and save that number to a variable? It seems very simple but I can’t find any documentation that explains how to do that. 

2 replies

rbkadiyam
Forum|alt.badge.img+17
  • rbkadiyam
  • Navigator | Tier 3
  • 582 replies
  • June 13, 2023

@Eddie Pequeno  execute select query and store output as variable (checkbox option)

Ramesh B Kadiyam
A
Forum|alt.badge.img+4
  • Aravindh483
  • Navigator | Tier 3
  • 20 replies
  • July 25, 2023

1) Database:Use export to datatable- select query and save Output to table variable

2) Datatable: get no of rows 

 

Thanks,

Aravindh s

Aravindhkumar002@gmail.com 

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings