Use Access module in SQL view

[SF]

Hi,

How can I use access function in SQL view or SP (like in access query)?

SF

 

[Douglas J. Steele]

You can't. SQL doesn't know anything about VBA.

Depending on what version of SQL Server you're using, you can create your
own functions there in T-SQL Take a look in BOL starting under CREATE
FUNCTION.

 

[SF]

Thanks.

SF

You can't. SQL doesn't know anything about VBA.

Depending on what version of SQL Server you're using, you can create your
own functions there in T-SQL Take a look in BOL starting under CREATE
FUNCTION.

 

[Guest]

Please tell us what you're trying to do.

There are pretty straight-forward replacements in most sitations.

like instead of using IIF, you use SELECT CASE, etc