SQL Source Control

Stairway to Database DevOps

Stairway to Database DevOps Level 3: Managing Code as a Team in Git

  • Stairway Step

In this level of the Stairway to Database DevOps, you'll get an introduction to branching and merging. Learn how to create a branch for making your changes to the codebase, submitting these in a code review, and then merging the changes into those made by other developers.

5 (2)

You rated this post out of 5. Change rating

2023-12-01

1,589 reads

Technical Article

Help us improve SQL Source Control

  • Article

We've been working really hard on SQL Source Control, and need your input. We're currently working on suggestions from our user forum and on an updated migrations feature that supports all source control systems and works across branches. We'd love it if you could spare 10 minutes to complete this survey. If you complete the survey by Friday June 14, you could win a $100 Amazon voucher. There are two up for grabs!

You rated this post out of 5. Change rating

2013-06-10

3,910 reads

Blogs

SQLpassion Live Training about running SQL Server in Microsoft Azure

By

From April 24 – 25, 2024 I will run a brand-new SQLpassion Live Training...

The Redgate Summit in Atlanta

By

Navigating the Database Landscape is the headline of our Redgate Summit in Atlanta on...

Friday Flyway Tips–Quick Command Line Access

By

One of the things I had to do recently in a demo was access...

Read the latest Blogs

Forums

row changes per hour by TagID

By Bruin

I have a large table being written too every second with equipment (PLC) information....

row changes per hour by TagID

By Bruin

I have a large table being written too every second with equipment (PLC) information....

Indexing strategy very long text strings

By aaron.reese

Hey guys,  Just looking to see if anyone has any bright ideas how to...

Visit the forum

Question of the Day

Logical Operators

I have this table and data:

CREATE TABLE ProdList
(ProductID INT NOT NULL
, ProductName VARCHAR(100)
, ProductCategory VARCHAR(40)
, ProductSize VARCHAR(4)
, ProductColor VARCHAR(20)
)
GO
INSERT dbo.ProdList
  (ProductID, ProductName, ProductCategory, ProductSize, ProductColor)
VALUES
  (1, 'Dirt Bike', 'Bike', '26', 'Blue'),
  (2, 'Mtn Bike', 'Bike', '26', 'Red'),
  (3, 'Dirt Bike', 'Bike', '24', 'Blue'),
  (4, 'Downhill', 'Ski', '180', 'White'),
  (5, 'Telemark', 'Ski', '175', 'Blue'),
  (6, 'Snowboard', 'Ski', '182', 'Various'),
  (7, 'Goggles', 'Ski', 'L', 'Clear')
How many rows are returned from this code:
SELECT productid, pl.ProductName
 FROM dbo.ProdList AS pl
 WHERE pl.ProductCategory = 'Bike'
 OR pl.ProductCategory = 'Ski'
 AND pl.ProductColor = 'Red'

See possible answers