Active Query Builder support area

About Sql Server functions

Avatar
  • updated
  • Completed

Hello , my company as finally bought a license, not directly through me but, someone higher in our company's hierarchy. I would just need to know what exactly is supported in regards to TSQL functions, [Scalar,TableValued,Stored Procs] it is not very clear in the documentation and I need to know this to moderate they're expectations.

Avatar
Andrey Zavyalov, PM

Hello,

You can use any scalar functions in SQL expressions: just type them in Expression or Criteria cells of the Query Columns Grid. Table-valued functions are shown in the Database Schema Tree, as they can be used as datasources in SELECT queries. Stored Procs are not shown in the tree, as they can only be used in EXEC statements, while Active Query Builder is intended to build only SELECT statements.