阅读背景:

创建用作表值参数的通用类型

来源:互联网 

I'm finding that there are several points in the stored procedures that I'm creating where I want a stored procedure to accept a list of IDs in various tables that the SP should perform an operation on. I'm considering using Table Value Parameters. What I'm wondering about is whether it's a good practice to create a single Type which just contains a single "ID int" column, and use that as the data type for all of my TVP's, or whether it's a better practice to define a type for each SP, in case I end up in the future wanting to expand the values passed.I'm finding that there are several points in th




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: