SQLite has several modes and settings that enable you to output query results as a comma-separated list.
For example, you can use the .separator dot command to specify a comma as the separator. Or you could use the “quote” mode to format the output as string literals.
However, for the purposes of this article, I’m going to use csv mode, which formats the results as a comma-separated list, as well as with double quotes around strings. Internal double quotes are double-quoted.
When working with the SQLite command line shell, you have the option of having your query results formatted as string literals.
You can do this by switching to “quote” mode. When you do this, strings are enclosed in single-quotes and internal single-quotes are escaped by doubling. Also, blobs are displayed in hexadecimal blob literal notation, numbers are displayed as ASCII text, and NULL values are shown as “NULL”.
If you need to format your results with double quotes, consider using csv mode.
By default, the SQLite command line shell formats query output as a pipe-separated list, without column headers.
If you need to output the results using commas instead of the pipe-symbol, you can specify this with the .separator dot command.
If you need to format your results as string literals, see How to Enclose Strings in Single Quotes. Or if you need any strings to be enclosed in double quotes, see How to Format Results as CSV.
By default, when you connect to the SQLite command line shell and run a query, the result is returned as a pipe separated list.
You might have noticed that the results don’t include the column names, which can make your results confusing if you’re trying to read them, especially if the query returned many columns.
Fortunately, there’s an easy way to format the output so that it’s displayed as a column with column headers.
In SQL Server, you can use GOTO to alter the flow of execution. You can use it to “jump” to another part in the T-SQL code.
The way it works is, you create a label, then you can use GOTO to jump to that label. Any code between GOTO and the label are skipped, and processing continues at the label.
GOTO statements and labels can be used anywhere within a procedure, batch, or statement block. They can also be nested.
In SQL Server, you can use any of the following five ways to return a list of temporary tables using Transact-SQL.
These return both local and global temporary tables.
Here’s some T-SQL code you can use to get a list of all CHECK and foreign key constraints in a SQL Server database.
The RAND() function in SQL Server returns a pseudo-random float value from 0 through 1, exclusive.
This function can be deterministic or nondeterministic, depending on how it’s invoked.