Which data types are no longer recommended to use in SQL Server 2008 R2?
I have read from the internet that unless you work wit开发者_如何学Pythonh old version sql server databases, now datetime2
is recommended to use.
It is just one type I know. Is there a list of data types which we should avoid using?
Under "Features Not Supported in a Future Version of SQL Server" in MSDN
- text
- ntext
- image
- timestamp alias for rowversion
datetime2 + date + time are new types with SQL Server 2008
精彩评论