The use of T-SQL variables, control structures and user defined functions permits to execute a set of instructions on the server side. This option reduces the number of instructions on the client side and also the size of packets to be transported trough the internet between client and server side. This means that less information needs to be used on the client side accelerating the process of publishing the data.
Access here to read the full article
No responses yet