Generate a SQL Script
Do you need to generate a SQL script (a text file of SQL commands in an sql file) […]
SQL Server
SQL Server COUNT DISTINCT
You can count the number of unique values in a column with COUNT DISTINCT. The Microsoft Press book […]
T-SQL Tables and Row Count
You are exploring a database in SQL Server using SSMS. You need a script that simply reports the […]
SQL Select Into
The SELECT INTO statement copies data from one table into a new table. Here’s the syntax for copying […]
SQL Update From Another Table
We want to add a new column to our Orders table and put the product name into that […]
SQL Add Column
What is the SQL statement that adds a column to an existing table? The SQL statement is the […]
SQL Update Statement
The UPDATE statement is used to modify the existing records in a table. The syntax is as follows. […]
SQL Server Recovery Pending
Are you working with SQL Server Management Studio (SSMS)and do you see one or more of your databases […]
SQL Update one Table from Another
Are you working with an SQL database where you need to copy data from one table to another? […]
T-SQL Parsing a New Table
So far we’ve created a lot of new columns. These are only temporary columns because what we really […]
T-SQL Parsing Groups of 4
Since we are going to use PARSENAME to process/parse the string, and it works with a maximum of […]
T-SQL Parsing One Fruit per Column
Below is the code to add the new columns. Each fruit must ultimately be in its own column, […]