开发者

Query taking long time to insert data in sql server express

开发者 https://www.devze.com 2023-01-06 20:26 出处:网络
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 i

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消