access 尝试读取或写入受保护的内存。这通常指示其他内存已损坏。

lcbird2010 2012-08-08 10:14:02

这是我的sql语句： select top 16 multiple_id, multiple_subject, trainee_name, difficulty, given_time, section_id from multiple_question_info as A, trainee_info as B where subject_id = 24 and A.trainee_id = B.trainee_id and is_multiple = 0 and A.is_deleted = 0 and multiple_id <> 2698 and multiple_id <> 2697 and multiple_id <> 2696 and multiple_id <> 2695 and multiple_id <> 2694 and multiple_id <> 2693 and multiple_id <> 2692 and multiple_id <> 2691 and multiple_id <> 2690 and multiple_id <> 2689 and multiple_id <> 2688 and multiple_id <> 2687 and multiple_id <> 2686 and multiple_id <> 2685 and multiple_id <> 2684 and multiple_id <> 2683 and multiple_id <> 2682 and multiple_id <> 2681 and multiple_id <> 2680 and multiple_id <> 2679 and multiple_id <> 2678 and multiple_id <> 2677 and multiple_id <> 2676 and multiple_id <> 2675 and multiple_id <> 2674 and multiple_id <> 2673 and multiple_id <> 2672 and multiple_id <> 2671 and multiple_id <> 2670 and multiple_id <> 2669 and multiple_id <> 2668 and multiple_id <> 2667 and multiple_id <> 2666 and multiple_id <> 2665 and multiple_id <> 2664 and multiple_id <> 2663 and multiple_id <> 2662 and multiple_id <> 2661 and multiple_id <> 2660 and multiple_id <> 2659 and multiple_id <> 2658 and multiple_id <> 2657 and multiple_id <> 2656 and multiple_id <> 2655 and multiple_id <> 2654 and multiple_id <> 2653 and multiple_id <> 2652 and multiple_id <> 2651 and multiple_id <> 2650 and multiple_id <> 2649 and multiple_id <> 2648 and multiple_id <> 2647 and multiple_id <> 2646 and multiple_id <> 2645 and multiple_id <> 2644 and multiple_id <> 2643 and multiple_id <> 2642 and multiple_id <> 2641 and multiple_id <> 2640 and multiple_id <> 2639 and multiple_id <> 2638 and multiple_id <> 2637 and multiple_id <> 2636 and multiple_id <> 2635 order by multiple_id desc

执行完后就报错尝试读取或写入受保护的内存。这通常指示其他内存已损坏。是不是我的sql语句太长了？因为我把sal语句改短一点后，就可以执行没有错误。哪位大牛能指点一下，谢谢了！！！

...全文

126 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

lcbird2010 2012-08-09

打赏
举报

[Quote=引用 4 楼的回复:]

1879 个字符长度，的确是些长了。改成如下试试吧。

select top 16 multiple_id, multiple_subject, trainee_name, difficulty, given_time, section_id
from multiple_question_info as A, trainee_info as B
where subject_i……
[/Quote]

谢谢啊现在可以了帮了大忙！！！

ACMAIN_CHM 2012-08-08

打赏
举报

1879 个字符长度，的确是些长了。改成如下试试吧。

select top 16 multiple_id, multiple_subject, trainee_name, difficulty, given_time, section_id
from multiple_question_info as A, trainee_info as B
where subject_id = 24 and A.trainee_id = B.trainee_id and is_multiple = 0 and A.is_deleted = 0
and multiple_id not in (2698,2697,2696,2695,2694,2693,2692,2691,2690,2689,2688,2687,2686,2685,2684,2683,2682,2681,2680,2679,2678,2677,2676,2675,2674,2673,2672,2671,2670,2669,2668,2667,2666,2665,2664,2663,2662,2661,2660,2659,2658,2657,2656,2655,2654,2653,2652,2651,2650,2649,2648,2647,2646,2645,2644,2643,2642,2641,2640,2639,2638,2637,2636,2635)

lcbird2010 2012-08-08