B
Brian K. Maher
Guest
Malick, That depends on your needs. If you need to work with or pass around from one place (client to appserver or appserver to client or procedure to procedure) multiple temp-tables as a single object then datasets are the way to go. If you need to do the same with just a single temp-table then give consideration to just using a temp-table. As for them being dynamic vs static, that also depends on your needs. Static are simpler to use but dynamic are more, well, dynamic in that you can construct the temp-table/dataset on the fly with schema you need and pass it around. For me, the downside to dynamic is that more coding is required and both sides of the equation need to be able to understand what they are receiving and be able to deal with it .. imagine passing a dynamic dataset across the wire to an appserver. The program you are running on the appserver and passing this dataset to needs to be able to understand what it is receiving and handle it. Perhaps it would be better if you told us what the actual problem is you are trying to resolve. Brian
Continue reading...
Continue reading...