SQL Server How-To Guides

Practical SQL Server answers with statements you can copy and run.

• How to Use COALESCE in SQL Server
• How to Create a Table in SQL Server
• How to Rename a Table in SQL Server
• How to Rename a Column in SQL Server
• How to Add a Column in SQL Server
• How to Drop a Column in SQL Server
• How to Change a Column Type in SQL Server
• How to Insert Data in SQL Server
• How to Update Rows With a Join in SQL Server
• How to Delete Rows With a Join in SQL Server
• How to Truncate a Table in SQL Server
• How to Duplicate a Table in SQL Server
• How to Create a View in SQL Server
• How to List Tables in SQL Server
• How to Describe a Table in SQL Server
• How to Upsert in SQL Server (MERGE or UPDATE + INSERT)
• How to Get the Current Date and Time in SQL Server
• How to Use DATEADD and DATEDIFF in SQL Server
• How to Format Dates in SQL Server
• How to Concatenate Strings in SQL Server
• How to Use STRING_AGG in SQL Server
• How to Find Duplicate Rows in SQL Server
• How to Remove Duplicate Rows in SQL Server
• How to Limit Rows in SQL Server (TOP and OFFSET FETCH)
• How to Use CASE Statements in SQL Server
• How to Reset an Identity Column in SQL Server
• How to Create an Index in SQL Server
• How to Use Temp Tables in SQL Server
• How to Kill a Query in SQL Server
• How to Check Table Sizes in SQL Server

Running SQL Server queries as a team? See the SaturnSQL SQL Server editor.