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. (1348 Views)