A quick review of Microsoft SQL Server object types

  • Tables are the source of your data
  • Views are transformations of data. They are usually used to combine information from multiple tables, but they can’t have parameters in them, so they are not what to use if you want to filter your data
  • User defined function or Stored procedure is the Swiss knife of SQL server. They can do anything from automated transformation of data to data retrieval. Code generation tools usually support calling them

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.