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.
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:
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:
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:
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.
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
Shortcuts for Use in the Editor
TeamSQL Quick Start for macOS
This guide is designed to get you up and running with TeamSQL as quickly as possible.
Drag and drop the TeamSQL icon onto the icon for your Applications folder.
3. Wait for the files to copy to your Applications folder.
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 ...