People generally ask me about resources for learning SQL. SQL is a great language for any database administrator to learn, because it gives you full control of the data, without limiting you to an application’s graphic user interface (GUI). With SQL you can query for records, and add, edit or remove them. This post is …
Tag :text entries
TMS + Social Media
Institutions are increasingly engaging with their audiences through social media. This presentation is full of insights into why social networking is an important component of outreach, and explores how TMS can be used to coordinate institution activities on such platforms as Facebook, Twitter, Flickr, Wikipedia, and more.
Text Entries in a Single View
If you’re anything like me, you probably have a stack of SQL views just to simplify report writing. Since text entries are so pervasive to TMS’s operation, I find that I am constantly making use of them in various Crystal Reports. Here’s a time-saver: a SQL view that combines the four tables used for controlling …