SQL Alter Table Alter Column SQL Server Management
When you have to alter a table that was inherited by you from the 90's or you're finally updating that old Access DB.
For some of you this will be a blessing.
/****** Object: Table [dbo].[TABLE_NAME] Script Date: 05/05/2014 19:19:10 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
ALTER TABLE [dbo].[TABLE_NAME] ALTER COLUMN [COLUMN_NAME] [nvarchar](MAX)
UPDATE [dbo].[TABLE_NAME] set [COLUMN_NAME] = [COLUMN_NAME]
You don't have to believe me:
I just updated 5 SQL sites in 30 minutes because ... I read and confirmed that StackOverflow.com is first in my book.
I knew it was something like that but seeing others discuss it and finalize it for me to test on an old SQL 2000 server I just migrated was awesome.
Thanks StackOverflow.Com ..