arnipetursson (1/15/2013)
Another valid use case is of course as input parameter to a stored proc.Again, if i have a substantial amount of data in the table variable input parameter,
I immediately move the data into an appropriately indexed # temp table.
Good point. Forgot about those, since they don't use them the place I currently work. Apparently, ColdFusion can't call those in its SQL modules. Or, at least, the version they're using can't. Maybe a later version can.
Table Value Parameters are very cool. Easy to pass datasets to from .NET applications.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon