Changing non-nullable column to nullable in SQL Server is quick and painless

Haidong Ji 发表于 2016年09月19日 02:35 | Hits: 1224
Tag: SQLServer | Technology

In T-SQL, you can only ALTER COLUMN one at a time. Initially I was worried about operational cost of this change, but it turned out this change is instantaneous.

Mind you, I’m not suggesting you should do this without a good reason.

原文链接: http://www.haidongji.com/2016/09/18/changing-non-nullable-column-to-nullable-in-sql-server-is-quick-and-painless/

0     0