SQL Server - Change the datatype of a Timestamp column.

By [)ia6l0 iii

There is no workaround to change the datatype of a Timestamp column. You will have to drop the column and recreate it.

Related FAQs

11g provides the following new features over 10g
Normalization in databases refers to representing data in a manner with least representation so that its accessible in all the ways.
The error means that you attempted to truncate a table with unique/primary key that is referenced as foriegn key in another table.
You can now do the inline variable assignment in SQL Server 2008.
Varchar can store non-Unicode character data where as nvarchar can store Unicode character data.
User Defined functions can be used inside a Select clause or a conditional statement such as Case. It can also be used in filtering statements such as Where. User Defined functions need to return a value, where as Stored procedures may not return. Stored are pre-compiled unlike the functions that are compiled at runtime.
SQL Server - Change the datatype of a Timestamp column.  (1281 Views)