About Sql Server functions

Answered

Comments

1 comment

  • Official comment
    Avatar
    Sergey Smagin (Product manager)

    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.

    Comment actions Permalink

Please sign in to leave a comment.