SQLSailor.com

Blogs

Securing Kubernetes With External Secrets Operator on AWS

By

Here’s a way to centralize management, rotate secrets conveniently without downtime, automate synchronization and...

Save Azure PostgreSQL Backup to Storage

By

This may or may not be helpful in the long term, but since I’m...

The Book of Redgate: What’s Great about Redgate?

By

“I’m sick of hearing about Red Gate.” The first article in the book has...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

Pitfalls to avoid while feeding events into CrowdStrike

By Pablo Echeverria

Comments posted to this topic are about the item Pitfalls to avoid while feeding...

Column Adds and Drops

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Column Adds and Drops

Visit the forum

Question of the Day

Column Adds and Drops

I run this batch on SQL Server 2022. What happens? 

ALTER TABLE dbo.Accounts
 ADD AccountAccessType INT
GO
ALTER TABLE dbo.Accounts
 DROP AccountAccessType
GO

See possible answers