Learn SQL

Article

Before data can be read from of a SQL Server database table, the table needs to contain rows of data. One of the most typical ways to get data into a table is to use the INSERT statement. One row or multiple rows can be inserted with a single execution of an INSERT statement. You can even use the output of a stored procedure to insert rows. In this article, I will explore the basics of inserting data into a SQL Server table using the INSERT statement.

2022-10-19

The ins and outs of joining tables in SQL Server

by Additional Articles

SimpleTalk

Learn SQL

Article

Most database queries require joining tables. In this article, Greg Larsen explains the ins and outs of joining tables in SQL Server.

2022-05-13

Ordering a result set in SQL Server

by Additional Articles

SimpleTalk

Learn SQL

Article

To guarantee the order of a result set, you must use an ORDER BY clause. In this article, Greg Larsen explains what you need to know about ORDER BY.

2022-04-08

When to use CHAR, VARCHAR, or VARCHAR(MAX)

by Additional Articles

SimpleTalk

Learn SQL

Article

It’s important to choose the right datatypes when designing a database. Greg Larsen explains the differences between CHAR, VARCHAR and VARCHAR(MAX).

2022-02-14

How to replace an identity column with a sequence number

by Additional Articles

SimpleTalk

Learn SQL

Article

SQL Server provides two ways to include an incrementing number in a table. Greg Larsen explains how to replace an identity column with a sequence number.

2022-01-24

How to return multiple sequence numbers with sp_sequence_get_range

by Additional Articles

SimpleTalk

Learn SQL

Article

Developers can work with multiple range values at once using sp_sequence_get_range. Greg Larsen explains how to return multiple sequence numbers with sp_sequence_get_range.

2022-01-05

Discuss

Using SQL Server sequence objects

by Additional Articles

SimpleTalk

Learn SQL

Article

SQL Server sequence objects have several properties that control how they behave. Greg Larson explains the options of using SQL Server sequence objects.

2021-12-06

Introduction to SQL Server sequence objects

by Additional Articles

SimpleTalk

Learn SQL

Article

SQL Server sequence objects can be used in place of identity columns. In this article, Greg Larsen explains how to set up and use sequence objects.

2021-11-17

Discuss

Working with SQL Server identity columns

by Additional Articles

SimpleTalk

Learn SQL

Article

SQL Server identity columns are easy to add to a table, but you must understand how they work to use them effectively. In this article, Greg Larsen explains the nuances of SQL Server identity columns.

2021-10-22

SQL Server identity column

by Additional Articles

SimpleTalk

Learn SQL

Article

The SQL Server identity column is used to populate a column with incrementing numbers on insert. In this article, Greg Larsen explains how it works.

2021-09-13

Learn SQL

The Basics of Inserting Data into a SQL Server Table

The ins and outs of joining tables in SQL Server

Ordering a result set in SQL Server

When to use CHAR, VARCHAR, or VARCHAR(MAX)

How to replace an identity column with a sequence number

How to return multiple sequence numbers with sp_sequence_get_range

Using SQL Server sequence objects

Introduction to SQL Server sequence objects

Working with SQL Server identity columns

SQL Server identity column

Blogs

AI: Blog a Day – Day 7: Vector and Vector Databases

AI: Blog a Day – Day 6: Embeddings – How AI Understands

The Book of Redgate: Mistakes

Forums

Why End-User Testing Is Even More Important with AI

Dynamic Unpivot

Writing as an Art and a Job

Question of the Day

String Similarity II