Browse by Tags

  • Using Table Aliases

    Table aliases are an often overlooked, underused, and confusing facet of database management systems. While table alaises may be confusing at first, they are wonderful for making queries easier to read, and easier to write. A table alias is nothing more than assigning a pseudo name to a table name in a SQL statement. For example, the following SELECT statement DOES NOT use a table alias because it is not helpful to do so. Table aliases are most helpful when you're joining two or more tables and...
  • Management Studio Quick Keys

    SQL Server Management Studio provides some neat shortcut features that makes it very quick easy to run certain stored procedures if you're in a hurry. Using these shortcut keys, you can assign administrative procedures to certain keyboard combinations to allow for quick execution without having to type the procedure name. First, from the Tools menu, select Options. Once on the Options screen, select the Keyboard option in the Environment menu. On they Keyboard menu, you can assign certain stored...
Copyright SQL Server Nation 2010
Powered by Community Server (Non-Commercial Edition), by Telligent Systems