In SQL Server it is generally a good idea to use temporary tables, rather than table variables within your stored procedures. Temporary tables perform much better, particularly with large volumes of data, as SQL Server is able to compile statistics on the data in temporary tables. However, if you are calling your stored procedures from a Powerbuilder application, you may find that the switch to temporary tables has an unwanted side effect. Here is how the unwanted side effect comes around and what to do about it.
https://www.selecttop.co.uk/440194269
https://www.youtube.com/watch?v=7QK-N6dQxNg
Comments (0)