Tag: Temporary Tables

Maine – SQL Server User Group – May 2014

admin

I am delighted about the opportunity to present at the Maine SQL Server User Group on May 7, 2014. This group meets at the Tyler Technologies facility in Yarmouth, ME. I have not been to Maine since a white water rafting trip on the Kennebec River with Crab Apple rafting company in July of 2012. Two times in the next month I will be visiting this northeastern most state. Do not forget to drop by the SQL Saturday #293 event in Portland ME on June 28th. I look forward to…

User Defined Views – Part 2

admin

Today, I want to continue talking about database objects that are associated with stored (compiled) code. A view can be though as a virtual table whose contents are defined by a TSQL query based on one or more tables in the database.   Typical uses of a view are the following: To simplify or customize the perception each user has of the database. Security mechanism to grant users access to the view, not the underlying base tables. To provide a backward compatible interface to emulate a table whose schema has…