Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Passing table variable to a function

Author  Topic 

na2173
Starting Member

38 Posts

Posted - 2001-12-18 : 12:13:48
can you pass a table variable to a function , if so not, sql_variant can be passed, can i conver sql_variant into table variable in the function

Onamuji
Aged Yak Warrior

504 Posts

Posted - 2001-12-18 : 12:27:21
scalar_parameter_data_type

Is the parameter data type. All scalar data types, including bigint and sql_variant, can be used as a parameter for user-defined functions. The timestamp data type and user-defined data types not supported. Nonscalar types such as cursor and table cannot be specified.


- Onamuji
Go to Top of Page
   

- Advertisement -