• Home
  • The Museum System
  • Business Intelligence
  • About Chad

Chad Petrovay

Tips and tricks for cultural heritage data management

Month: May 2014

SQL Scripting

Select Top 3 * From [Uses for Select]: Part 2

Chad Petrovay 06 May , 2014 1

In Part 1, we examined how to use the SELECT statement in SQL to create a SQL View that can be used in Crystal Reports for reporting. There are two additional uses for the SELECT statement, which make learning its syntax an invaluable tool for database administrators.

Tweet
Share
Share
Pin
Continue Reading

Tags

advanced query Alternate Numbers backup solution batch assign bibliography Collective Imagination Constituents contact details Crystal Reports data profiling data quality data scrubbing data security data standards dbconfig digital images end-user support Events freebie Function key intangible objects library system list view Location Authority Locations Authority Media Objects Packages permissions Photosynth preaccession productivity querying Reluctant DBA remote access security group slide deck Social media SQL View statistics status flags text entries training virtual objects webinar

Categories

  • Business Intelligence (6)
  • Data Governance (4)
  • Database Administration (5)
  • Miscellanea (2)
  • SQL Scripting (17)
  • The Museum System (25)
  • xperience Gallery (2)
Chad Petrovay All rights reserved.
Powered by WordPress Theme by alfisahr