34,874
社区成员
发帖
与我相关
我的任务
分享入门问题 2 个。
IF SELECT COUNT(*) FROM SALESORDER = SELECT COUNT(*) FROM SALESORDER WHERE QTY_COMPLETE = 1
PRINT '全部完成'
还有怎样实现这种赋值
declare @count int
select @count = SELECT COUNT(*) FROM SALESORDER
...全文
请发表友善的回复…
发表回复
yujohny 2003-08-28
- 打赏
- 举报
IF (SELECT COUNT(*) FROM SALESORDER) = (SELECT COUNT(*) FROM SALESORDER WHERE QTY_COMPLETE = 1)
PRINT '全部完成'
declare @count int
select @count = COUNT(*) FROM SALESORDER
PRINT '全部完成'
declare @count int
select @count = COUNT(*) FROM SALESORDER
