更新时间:2023-01-19 16:54:36
是的,这是可能的。
但是,我不认为这是可能的凡(...)
。
Yes, it is possible.
However, I don't think it's possible with WHERE IN (...)
.
下面是一个正常的,其中
查询一个例子:
Here is an example for a normal WHERE
query:
Public Function Test() As String
Test = "Smith"
End Function
...然后:
...and then:
SELECT * FROM Users WHERE Name = Test();
它的工作原理,只要把函数只返回一个值。
但我认为它的不可以可以让你的函数返回类似史密斯,米勒并使用,如:
It works, as long as the function only returns one value.
But I think it's not possible to let your function return something like "Smith, Miller" and use that like:
SELECT * FROM Users WHERE Name In (Test());
(至少我不知道如何做到这一点)
(at least I don't know how to do it)