UPDATE Relay SET Used = 1
FROM Relay
WHERE RelayPhone IN (SELECT TOP 1 @RelayPhone =RelayPhone FROM Relay WHERE (Used = 0))
==>
改成
Update Relay Set Used=1 from Relay where RelayPhone=@RelayPhone and Used='0'不就可以了吗?
FROM Relay
WHERE RelayPhone IN (SELECT TOP 1 @RelayPhone =RelayPhone FROM Relay WHERE (Used = 0))
==>
改成
Update Relay Set Used=1 from Relay where RelayPhone=@RelayPhone and Used='0'不就可以了吗?
解决方案 »
- 怎么做字符转日期才不溢出?
- 请教支持多表调用的分页存储过程。我使用select_pagesize两张表联合调用时可以分页。但是三张表时却不成。请教怎么修改使它真正的支持多
- 在SQL Server里这个过程怎么实现?
- tempdb和数据库的log文件不断的增长,只有每天重启服务来释放tempdb的空间
- sql server连接oracle数据库出问题了.....急!!!!!!
- SQL行转列的问题..(有详细需求了..)...在线等...急!!!急!!!急!!!急!!!
- 数据库问题
- 求救!
- 关于InterBase的两个很重要的问题!!送95分。
- 安装SQLServer2012时,到“功能选择”这一步时,一般初学者应该选择哪几项呢,全选的话很多功能根本用不上,请高手指点一二。
- 急问题:如何将varcher类型的字段更新为money类型?
- 那位帮我看看这段存储过程怎么了
FROM Relay
WHERE RelayPhone IN (SELECT TOP 1 RelayPhone FROM Relay WHERE (Used = 0))
WHERE RelayPhone = (SELECT TOP 1 RelayPhone FROM Relay WHERE (Used = 0))
set rowcount 1
UPDATE Relay SET Used = 1,@RelayPhone =RelayPhone
WHERE userd=0
set rowcount 0
SET Used = 1 ,
@RelayPhone =RelayPhone
FROM Relay
WHERE RelayPhone = (SELECT TOP 1 RelayPhone FROM Relay WHERE Used = 0)