§如何获取执行结果？

[blackwind]

我在触发器里写的：
execute("insert into Receive_"+@city+" (mobile,content,seatid) select top 1 '"+ @mobile+"','"+@content+"',seatid from seat_"+@city+"where DATEADD(minute,2,visittime) >getdate() order by assigntime")

怎样得知：有没有insert成功？？？

[blackwind]

就是有数据插入了？

[yesterday2000]

execute("insert into Receive_"+@city+" (mobile,content,seatid) select top 1 '"+ @mobile+"','"+@content+"',seatid from seat_"+@city+"where DATEADD(minute,2,visittime) >getdate() order by assigntime")

if @@rowcount=0
print '注意：没有记录得到更新'
else print '已经更新了'

[47522341]

@@rowcount,
上條查詢語句執行后影響的紀錄條數.