Query taking long time to insert data in sql server express
I have strange scenario in which if I create database using SQL Server 2008 Express (database compatibility level SQL Serv开发者_如何转开发er 2008) and perform insert using xml datatype, it executes indefinitely, but when same query is executed on database with compatibility level SQL Server 2005 it runs fine and executes in less than one minute.
Thanks
Microsoft has whitepapers about changes between SQL2005 and 2008. I would look there for any related breaking changes. If you expect to get an adequate answer on this site I would suggest posting code.
精彩评论