SQL死锁问题：Transaction (Process ID 65) was deadlocked on lock resources with...

[kingmax54212008]

SqlExecuteException: Sql Statement: bele_Users_FindUsers
Parameters: [@PageIndex,0],[@PageSize,50],[@PopulateSql,SELECT UserID FROM vw_UserDetails WHERE 1=1 ORDER BY SignupDate DESC],[@ExecSqlLimit,SELECT vp.UserID AS UserID, vp.UserName AS UserName, vp.FirstName AS FirstName, vp.LastName AS LastName, vp.NickName AS NickName, vp.Birthday AS Birthday, vp.Source AS Source, vp.Address AS Address, vp.Country AS Country, vp.City AS City, vp.QQ AS QQ, vp.MSN AS MSN, vp.Telephone AS Telephone, vp.IPAddress AS IPAddress, vp.SignupDate AS SignupDate, vp.AccountStatus AS AccountStatus, vp.AccountType AS AccountType, vp.WantsEmail AS WantsEmail FROM #PageIndex PI INNER JOIN vw_UserDetails vp on PI.UserID = vp.UserID WHERE IndexID > 0 AND IndexID < 51 ORDER BY CreateDate DESC],[@ExecSqlAll,SELECT vp.UserID AS UserID, vp.UserName AS UserName, vp.FirstName AS FirstName, vp.LastName AS LastName, vp.NickName AS NickName, vp.Birthday AS Birthday, vp.Source AS Source, vp.Address AS Address, vp.Country AS Country, vp.City AS City, vp.QQ AS QQ, vp.MSN AS MSN, vp.Telephone AS Telephone, vp.IPAddress AS IPAddress, vp.SignupDate AS SignupDate, vp.AccountStatus AS AccountStatus, vp.AccountType AS AccountType, vp.WantsEmail AS WantsEmail FROM #PageIndex PI INNER JOIN vw_UserDetails vp on PI.UserID = vp.UserID ORDER BY CreateDate DESC],[@TotalRecords,],
System.Data.SqlClient.SqlException: Transaction (Process ID 65) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Quick.Data.SqlBaseDb.SelectReader(String sql)
at Quick.Data.SqlBaseDb.SelectReader(String sql)
at BelePlay.Data.SqlPlayerProvider.QueryUserInfo(PlayerQuery query, String providerName)
at BelePlay.Players.PlayerManager.QueryUserInfo(PlayerQuery query, String providerName)
at BelePlay.BackOffice.UserControl.Member.SearchPlayers.HandlePagerIndex(PlayerQuery queryScript, PageListSet`1& ds)
at BelePlay.BackOffice.UserControl.Member.SearchPlayers.QueryBind()

[kingmax54212008]

报出这个错误，哪位帮我看看，如何能够防止死锁问题？

[Q315054403]

单纯地这样找不答案的。。

[无锡阔微信息科技]

太多了，看不清楚，等待牛人

[starseeker7]

誰這樣能找出答案就真不是牛人
是神人了

[jieluen2002]

也碰到类似问题

[kingmax54212008]

哦。我这最后找到原因，
变量@variable
使用的是：
select @variable = columnName
from QueryRecordSets

类似这种查询，返回的数据集合不唯一。使得负值失败。

[kingmax54212008]

希望对你（jieluen2002）有所帮助.