The Advantages of Writing Stored Procedures

Perhaps the title should be the disadvantages of sending SQL batches from client applications. Many people think that the primary advantage to stored procedures arises from the fact that they are optimized and compile once and then remain in memory, hopefully to be used again and again. While this can be an advantage, there are […]
Read More ›

Apply the Openrowset Function to Acquire Rowsets

In the previous blog on SQL Server’s OPENROWSET function we observed that while OPENROWSET is most often encountered in relation to linked servers, it is also valuable for directly reading flat files. It’s worth taking a moment to mention another less common application of OPENROWSET ( ). If you wanted to write code that returned […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.