Basic SQL
Command for DQL
SELECT
These symbols mean greater than or equal to?
>=
This word joins two conditions in the where line.
AND, OR
How do you specify the database that you are using for a query?
Specify the database in the dropdown in SQL-Server Management Studio, use the 'Use database' syntax, or input in the script the database name at the start of db objects.
A query nested within the WHERE clause of another query.
Used to create an alias
AS
This symbol means a wildcard.
%
This operator stands for equal to.
=
A tool where you write queries.
Query Design Window, Query Editor Window
SQL Statement to delete specific /all rows from a table
DELETE
This symbol brings back all the rows and columns.
*
This symbol means less than.
<
These operators bring back a range of values.
BETWEEN AND
How do you run an sql query?
Click the 'EXECUTE' command on the toolbar Or press F5.
It returns NULL when both parameters are the same.
NULLIF
This word limits the data brought back or retrieved.
WHERE
These symbols go around a list of values with the in operator.
( )
This operator searches for a pattern of letters.
LIKE
True or False: Number of integer datatypes can be specified in SSMS. Example: int(4)
FALSE
1
This symbol ends a SQL statement.
;
These symbols mean not equal.
!=, <>
This operator gives a list of values.
IN
A system stored procedure that can be used to rename a table, column or user-defined sp.
SP_RENAME
This operator combines the result set of two different queries. Number of columns and their datatypes in the two queries must match.
UNION / UNION ALL