You have a table called MyTable and have a column called MyColumn that is currently varchar with length of 500 and wish to make it length of 1000. This table is actually a production SQL Table.
ALTER TABLE MyTable ALTER COLUMN MyColumn VARCHAR(1000)
If you like this post and want to see more, follow me on my website www.chadcompton.com
Or if you prefer...