{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 劫难 的问题《Does SQL Server 2005 support datetime2》','https://www.manongdao.com/q-972502.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I can't seem to find in the official documentation if SQL Server 2005 supports datetime2 data type?
相关问题
- keeping one connection to DB or opening closing pe
- Quickest method for matching nested XML data again
- What are IN and OUT parameter in SQL Server
- How to migrate a database from SQL Server 2005 to
- Cannot insert NULL values into column 'USERNAM
相关文章
- Convert column to string in SQL Select
- Why not “Invalid column name XYZ” error in subquer
- Create @TableVariable based on an existing databas
- Convert bit type to Yes or No by query Sql Server
- Best Isolation Level to avoid deadlocks using an U
- How can i use pivot?
- Update and insert to one table from another
- Storing SSN/CC data
maybe you encounter this problem:
you can see the solution as following:
Using SQL Server 2008 and SQL Server 2005 and date time
Open your EDMX in a file editor (or “open with…” in Visual Studio and select XML Editor). At the top you will find the storage model and it has an attribute ProviderManifestToken. This has should have the value 2008. Change that to 2005, recompile and everything works.
NOTE: You'll have to do this every time you update the model from database.
Apparently it does not. Here are the supported data types.
EDIT:
According to the following sources datetime2 was introduced in SQL Server 2008.
http://blogs.msdn.com/b/manisblog/archive/2007/08/28/sql-server-2008-enhancements-in-date-and-time-data-types.aspx
http://www.4guysfromrolla.com/articles/101508-1.aspx