开发者

TSql Lookup function

I have a bunch of dimension tables that have unique ID and Name fields. I need a T-SQL function that returns an ID when p开发者_C百科assed a table name and a value for the name field.

I'm guessing the function would build a little query then execute it? Performance isn't an issue since this is a one time ETL thing.


Sounds like you want a scalar user defined function There's a lot of other ways to do it though, and udf's certainly can have some perfomance issues.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜