Recent Comments

This is default featured slide 1 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 2 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 3 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 4 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 5 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

顯示具有 MS SQL 標籤的文章。 顯示所有文章
顯示具有 MS SQL 標籤的文章。 顯示所有文章

2014年1月14日 星期二

MSSQL 防止儲存需要資料表重建的變更

上午8:42    No comments

當修改MSSQL資料表的資料型態或是否null時出現『防止儲存需要資料表重建的變更』
主要是因為某些設定會造成格式不符資料流失所出現的提醒，但在開發建立時會時常修改
可以在
『SQL Server Management Studio(SSMS) ->工具->選項->設計師->資料表和資料庫設計工具』
頁面中的『防止儲存需要資料表重建的變更』取消勾選後點選『確定』即可。




Read More
訂閱： 文章 (Atom)