[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1098
  • Last Modified:

Pass a table variable as UDF parameter?

Can I pass a table variable into a UDF as a parameter?
0
elmoredaniel
Asked:
elmoredaniel
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
No, only scalar types are permitted
All scalar data types, including bigint and sql_variant, can be used as a parameter for user-defined functions.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now