Increase the size of a nvarchar column

//Increase the size of the TagName column try { SqlCommand1 = gcnew SqlClient::SqlCommand(); SqlCommand1->Connection = SqlConnection1; SqlCommand1->CommandType = CommandType::Text; SqlCommand1->CommandText = “ALTER TABLE tblTagDefinitions ALTER COLUMN TagName [nvarchar](200) NULL”; affected = SqlCommand1->ExecuteNonQuery(); //affected = number of rows affected } catch (Exception ^) { }

Read More