S
SF
Hi,
How can I use access function in SQL view or SP (like in access query)?
SF
How can I use access function in SQL view or SP (like in access query)?
SF
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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.
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.
S
SF
Thanks.
SF
SF
Douglas J. Steele said: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.
G
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
There are pretty straight-forward replacements in most sitations.
like instead of using IIF, you use SELECT CASE, etc