Help 7 results

Cast vs. Convert

When working with Microsoft’s SQL Server (and by extension, T-SQL), you have two options when making explicit conversions: CAST and CONVERT. Many people use them frequently, and quite often interchangeably, but there are some cases when one is a better choice than the other. This post covers the similarities and the differences between the two, as well as when you’re better off using one over the other.     Similarities When doing explicit data conversions, CAST and ...

Providing Feedback on TeamSQL

  Thank you for taking part in our private beta and using TeamSQL. While we spend a lot of time testing to ensure that everything works as flawlessly as possible, we realize that your help in polishing our product is just as important. We use GitHub for issue tracking, so we welcome you to log any of the following to our GitHub repository: Bugs Usability issues Unintended features Feature requests Not only will this making tracking input easier, it provides an ...

Working with Teams in TeamSQL

In this article, we will cover the features TeamSQL has that enable easy collaboration between you and your colleagues.   Creating a Team To create a new team, which you can use to group any number of users, navigate to Teams > Create New Team using the main toolbar at the top. You will be prompted to provide a name for your new team.   Click Create to proceed. On the Teams & Management window that displays, you see your newly-created team, along ...

Saving and Managing Queries in TeamSQL

You can easily save the queries you execute in TeamSQL for future reference.     You can initiate a save by clicking Save Query, using CTRL + S (in Linux or Windows), or using ⌘ + S (in macOS). You will be prompted to provide a name for your query if this is the first time you’ve saved.   TeamSQL now displays the name of your query in the query’s tab, as well as in the left-hand navigation bar.   Viewing Your Saved Queries In addition to accessing ...

Exporting Data Using TeamSQL

    You can easily export the data contained in your database tables in one of the following formats: CSV JSON Tab Separated NOTE: You can connect to AWS Redshift with TeamSQL, a multi-platform DB client that works with Redshift, PostgreSQL, MySQL & Microsoft SQL Server and runs on Mac, Linux and Windows. You can download TeamSQL Beta for free: https://teamsql.io/   How to Export Data 1. Launch TeamSQL, and connect to your database server by ...

Using Keyboard Shortcuts in TeamSQL

There are numerous shortcuts that allow you to perform actions faster. Below is a list of shortcuts you can use in TeamSQL, as well as information on where you can use them.   Apple macOS   General Keyboard Shortcuts Open search box — search for any item ⌘ ⇧ F Open search box — search for table names ⌘ ⇧ T Open search box — search for functions and stored procedure ⌘ ⇧ P Import SQL file ⌘ O   Shortcuts for Use in the Editor Execute query ⌘ ...

TeamSQL Quick Start for macOS

This guide is designed to get you up and running with TeamSQL as quickly as possible.     Installation Download TeamSQL. Drag and drop the TeamSQL icon onto the icon for your Applications folder.   3. Wait for the files to copy to your Applications folder. Launch TeamSQL 1. Once TeamSQL has been installed, you can launch it using its icon located in your Launchpad. 2. You will be asked to register to use TeamSQL.   If you ...