[Solved] The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values

merictokatlioglu
 
on Mar 11, 2021 05:11 AM
1551 Views

Hello,

How can i insert more then 1000 row in mssql?

When i try more 1000 row then it will error

The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values.

 

Download FREE API for Word, Excel and PDF in ASP.Net: Download
dharmendr
 
on Mar 11, 2021 05:22 AM

Hi merictokatlio...,

Use UNION ALL.

DECLARE @Test AS table (c1 int)

INSERT INTO @Test
SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9 UNION ALL SELECT 10 UNION ALL SELECT 11 UNION ALL SELECT 12 UNION ALL SELECT 13 UNION ALL SELECT 14 UNION ALL SELECT 15 UNION ALL SELECT 16 UNION ALL SELECT 17 UNION ALL SELECT 18 UNION ALL SELECT 19 UNION ALL SELECT 20 UNION ALL SELECT 21 UNION ALL SELECT 22 UNION ALL SELECT 23 UNION ALL SELECT 24 UNION ALL SELECT 25 UNION ALL SELECT 26 UNION ALL SELECT 27 UNION ALL SELECT 28 UNION ALL SELECT 29 UNION ALL SELECT 30 UNION ALL SELECT 31 UNION ALL SELECT 32 UNION ALL SELECT 33 UNION ALL SELECT 34 UNION ALL SELECT 35 UNION ALL SELECT 36 UNION ALL SELECT 37 UNION ALL SELECT 38 UNION ALL SELECT 39 UNION ALL SELECT 40 UNION ALL SELECT 41 UNION ALL SELECT 42 UNION ALL SELECT 43 UNION ALL SELECT 44 UNION ALL SELECT 45 UNION ALL SELECT 46 UNION ALL SELECT 47 UNION ALL SELECT 48 UNION ALL SELECT 49 UNION ALL SELECT 50 UNION ALL 
SELECT 51 UNION ALL SELECT 52 UNION ALL SELECT 53 UNION ALL SELECT 54 UNION ALL SELECT 55 UNION ALL SELECT 56 UNION ALL SELECT 57 UNION ALL SELECT 58 UNION ALL SELECT 59 UNION ALL SELECT 60 UNION ALL SELECT 61 UNION ALL SELECT 62 UNION ALL SELECT 63 UNION ALL SELECT 64 UNION ALL SELECT 65 UNION ALL SELECT 66 UNION ALL SELECT 67 UNION ALL SELECT 68 UNION ALL SELECT 69 UNION ALL SELECT 70 UNION ALL SELECT 71 UNION ALL SELECT 72 UNION ALL SELECT 73 UNION ALL SELECT 74 UNION ALL SELECT 75 UNION ALL SELECT 76 UNION ALL SELECT 77 UNION ALL SELECT 78 UNION ALL SELECT 79 UNION ALL SELECT 80 UNION ALL SELECT 81 UNION ALL SELECT 82 UNION ALL SELECT 83 UNION ALL SELECT 84 UNION ALL SELECT 85 UNION ALL SELECT 86 UNION ALL SELECT 87 UNION ALL SELECT 88 UNION ALL SELECT 89 UNION ALL SELECT 90 UNION ALL SELECT 91 UNION ALL SELECT 92 UNION ALL SELECT 93 UNION ALL SELECT 94 UNION ALL SELECT 95 UNION ALL SELECT 96 UNION ALL SELECT 97 UNION ALL SELECT 98 UNION ALL SELECT 99 UNION ALL SELECT 100 UNION ALL 
SELECT 101 UNION ALL SELECT 102 UNION ALL SELECT 103 UNION ALL SELECT 104 UNION ALL SELECT 105 UNION ALL SELECT 106 UNION ALL SELECT 107 UNION ALL SELECT 108 UNION ALL SELECT 109 UNION ALL SELECT 110 UNION ALL SELECT 111 UNION ALL SELECT 112 UNION ALL SELECT 113 UNION ALL SELECT 114 UNION ALL SELECT 115 UNION ALL SELECT 116 UNION ALL SELECT 117 UNION ALL SELECT 118 UNION ALL SELECT 119 UNION ALL SELECT 120 UNION ALL SELECT 121 UNION ALL SELECT 122 UNION ALL SELECT 123 UNION ALL SELECT 124 UNION ALL SELECT 125 UNION ALL SELECT 126 UNION ALL SELECT 127 UNION ALL SELECT 128 UNION ALL SELECT 129 UNION ALL SELECT 130 UNION ALL SELECT 131 UNION ALL SELECT 132 UNION ALL SELECT 133 UNION ALL SELECT 134 UNION ALL SELECT 135 UNION ALL SELECT 136 UNION ALL SELECT 137 UNION ALL SELECT 138 UNION ALL SELECT 139 UNION ALL SELECT 140 UNION ALL SELECT 141 UNION ALL SELECT 142 UNION ALL SELECT 143 UNION ALL SELECT 144 UNION ALL SELECT 145 UNION ALL SELECT 146 UNION ALL SELECT 147 UNION ALL SELECT 148 UNION ALL SELECT 149 UNION ALL SELECT 150 UNION ALL 
SELECT 151 UNION ALL SELECT 152 UNION ALL SELECT 153 UNION ALL SELECT 154 UNION ALL SELECT 155 UNION ALL SELECT 156 UNION ALL SELECT 157 UNION ALL SELECT 158 UNION ALL SELECT 159 UNION ALL SELECT 160 UNION ALL SELECT 161 UNION ALL SELECT 162 UNION ALL SELECT 163 UNION ALL SELECT 164 UNION ALL SELECT 165 UNION ALL SELECT 166 UNION ALL SELECT 167 UNION ALL SELECT 168 UNION ALL SELECT 169 UNION ALL SELECT 170 UNION ALL SELECT 171 UNION ALL SELECT 172 UNION ALL SELECT 173 UNION ALL SELECT 174 UNION ALL SELECT 175 UNION ALL SELECT 176 UNION ALL SELECT 177 UNION ALL SELECT 178 UNION ALL SELECT 179 UNION ALL SELECT 180 UNION ALL SELECT 181 UNION ALL SELECT 182 UNION ALL SELECT 183 UNION ALL SELECT 184 UNION ALL SELECT 185 UNION ALL SELECT 186 UNION ALL SELECT 187 UNION ALL SELECT 188 UNION ALL SELECT 189 UNION ALL SELECT 190 UNION ALL SELECT 191 UNION ALL SELECT 192 UNION ALL SELECT 193 UNION ALL SELECT 194 UNION ALL SELECT 195 UNION ALL SELECT 196 UNION ALL SELECT 197 UNION ALL SELECT 198 UNION ALL SELECT 199 UNION ALL SELECT 200 UNION ALL 
SELECT 201 UNION ALL SELECT 202 UNION ALL SELECT 203 UNION ALL SELECT 204 UNION ALL SELECT 205 UNION ALL SELECT 206 UNION ALL SELECT 207 UNION ALL SELECT 208 UNION ALL SELECT 209 UNION ALL SELECT 210 UNION ALL SELECT 211 UNION ALL SELECT 212 UNION ALL SELECT 213 UNION ALL SELECT 214 UNION ALL SELECT 215 UNION ALL SELECT 216 UNION ALL SELECT 217 UNION ALL SELECT 218 UNION ALL SELECT 219 UNION ALL SELECT 220 UNION ALL SELECT 221 UNION ALL SELECT 222 UNION ALL SELECT 223 UNION ALL SELECT 224 UNION ALL SELECT 225 UNION ALL SELECT 226 UNION ALL SELECT 227 UNION ALL SELECT 228 UNION ALL SELECT 229 UNION ALL SELECT 230 UNION ALL SELECT 231 UNION ALL SELECT 232 UNION ALL SELECT 233 UNION ALL SELECT 234 UNION ALL SELECT 235 UNION ALL SELECT 236 UNION ALL SELECT 237 UNION ALL SELECT 238 UNION ALL SELECT 239 UNION ALL SELECT 240 UNION ALL SELECT 241 UNION ALL SELECT 242 UNION ALL SELECT 243 UNION ALL SELECT 244 UNION ALL SELECT 245 UNION ALL SELECT 246 UNION ALL SELECT 247 UNION ALL SELECT 248 UNION ALL SELECT 249 UNION ALL SELECT 250 UNION ALL 
SELECT 251 UNION ALL SELECT 252 UNION ALL SELECT 253 UNION ALL SELECT 254 UNION ALL SELECT 255 UNION ALL SELECT 256 UNION ALL SELECT 257 UNION ALL SELECT 258 UNION ALL SELECT 259 UNION ALL SELECT 260 UNION ALL SELECT 261 UNION ALL SELECT 262 UNION ALL SELECT 263 UNION ALL SELECT 264 UNION ALL SELECT 265 UNION ALL SELECT 266 UNION ALL SELECT 267 UNION ALL SELECT 268 UNION ALL SELECT 269 UNION ALL SELECT 270 UNION ALL SELECT 271 UNION ALL SELECT 272 UNION ALL SELECT 273 UNION ALL SELECT 274 UNION ALL SELECT 275 UNION ALL SELECT 276 UNION ALL SELECT 277 UNION ALL SELECT 278 UNION ALL SELECT 279 UNION ALL SELECT 280 UNION ALL SELECT 281 UNION ALL SELECT 282 UNION ALL SELECT 283 UNION ALL SELECT 284 UNION ALL SELECT 285 UNION ALL SELECT 286 UNION ALL SELECT 287 UNION ALL SELECT 288 UNION ALL SELECT 289 UNION ALL SELECT 290 UNION ALL SELECT 291 UNION ALL SELECT 292 UNION ALL SELECT 293 UNION ALL SELECT 294 UNION ALL SELECT 295 UNION ALL SELECT 296 UNION ALL SELECT 297 UNION ALL SELECT 298 UNION ALL SELECT 299 UNION ALL SELECT 300 UNION ALL 
SELECT 301 UNION ALL SELECT 302 UNION ALL SELECT 303 UNION ALL SELECT 304 UNION ALL SELECT 305 UNION ALL SELECT 306 UNION ALL SELECT 307 UNION ALL SELECT 308 UNION ALL SELECT 309 UNION ALL SELECT 310 UNION ALL SELECT 311 UNION ALL SELECT 312 UNION ALL SELECT 313 UNION ALL SELECT 314 UNION ALL SELECT 315 UNION ALL SELECT 316 UNION ALL SELECT 317 UNION ALL SELECT 318 UNION ALL SELECT 319 UNION ALL SELECT 320 UNION ALL SELECT 321 UNION ALL SELECT 322 UNION ALL SELECT 323 UNION ALL SELECT 324 UNION ALL SELECT 325 UNION ALL SELECT 326 UNION ALL SELECT 327 UNION ALL SELECT 328 UNION ALL SELECT 329 UNION ALL SELECT 330 UNION ALL SELECT 331 UNION ALL SELECT 332 UNION ALL SELECT 333 UNION ALL SELECT 334 UNION ALL SELECT 335 UNION ALL SELECT 336 UNION ALL SELECT 337 UNION ALL SELECT 338 UNION ALL SELECT 339 UNION ALL SELECT 340 UNION ALL SELECT 341 UNION ALL SELECT 342 UNION ALL SELECT 343 UNION ALL SELECT 344 UNION ALL SELECT 345 UNION ALL SELECT 346 UNION ALL SELECT 347 UNION ALL SELECT 348 UNION ALL SELECT 349 UNION ALL SELECT 350 UNION ALL 
SELECT 351 UNION ALL SELECT 352 UNION ALL SELECT 353 UNION ALL SELECT 354 UNION ALL SELECT 355 UNION ALL SELECT 356 UNION ALL SELECT 357 UNION ALL SELECT 358 UNION ALL SELECT 359 UNION ALL SELECT 360 UNION ALL SELECT 361 UNION ALL SELECT 362 UNION ALL SELECT 363 UNION ALL SELECT 364 UNION ALL SELECT 365 UNION ALL SELECT 366 UNION ALL SELECT 367 UNION ALL SELECT 368 UNION ALL SELECT 369 UNION ALL SELECT 370 UNION ALL SELECT 371 UNION ALL SELECT 372 UNION ALL SELECT 373 UNION ALL SELECT 374 UNION ALL SELECT 375 UNION ALL SELECT 376 UNION ALL SELECT 377 UNION ALL SELECT 378 UNION ALL SELECT 379 UNION ALL SELECT 380 UNION ALL SELECT 381 UNION ALL SELECT 382 UNION ALL SELECT 383 UNION ALL SELECT 384 UNION ALL SELECT 385 UNION ALL SELECT 386 UNION ALL SELECT 387 UNION ALL SELECT 388 UNION ALL SELECT 389 UNION ALL SELECT 390 UNION ALL SELECT 391 UNION ALL SELECT 392 UNION ALL SELECT 393 UNION ALL SELECT 394 UNION ALL SELECT 395 UNION ALL SELECT 396 UNION ALL SELECT 397 UNION ALL SELECT 398 UNION ALL SELECT 399 UNION ALL SELECT 400 UNION ALL 
SELECT 401 UNION ALL SELECT 402 UNION ALL SELECT 403 UNION ALL SELECT 404 UNION ALL SELECT 405 UNION ALL SELECT 406 UNION ALL SELECT 407 UNION ALL SELECT 408 UNION ALL SELECT 409 UNION ALL SELECT 410 UNION ALL SELECT 411 UNION ALL SELECT 412 UNION ALL SELECT 413 UNION ALL SELECT 414 UNION ALL SELECT 415 UNION ALL SELECT 416 UNION ALL SELECT 417 UNION ALL SELECT 418 UNION ALL SELECT 419 UNION ALL SELECT 420 UNION ALL SELECT 421 UNION ALL SELECT 422 UNION ALL SELECT 423 UNION ALL SELECT 424 UNION ALL SELECT 425 UNION ALL SELECT 426 UNION ALL SELECT 427 UNION ALL SELECT 428 UNION ALL SELECT 429 UNION ALL SELECT 430 UNION ALL SELECT 431 UNION ALL SELECT 432 UNION ALL SELECT 433 UNION ALL SELECT 434 UNION ALL SELECT 435 UNION ALL SELECT 436 UNION ALL SELECT 437 UNION ALL SELECT 438 UNION ALL SELECT 439 UNION ALL SELECT 440 UNION ALL SELECT 441 UNION ALL SELECT 442 UNION ALL SELECT 443 UNION ALL SELECT 444 UNION ALL SELECT 445 UNION ALL SELECT 446 UNION ALL SELECT 447 UNION ALL SELECT 448 UNION ALL SELECT 449 UNION ALL SELECT 450 UNION ALL 
SELECT 451 UNION ALL SELECT 452 UNION ALL SELECT 453 UNION ALL SELECT 454 UNION ALL SELECT 455 UNION ALL SELECT 456 UNION ALL SELECT 457 UNION ALL SELECT 458 UNION ALL SELECT 459 UNION ALL SELECT 460 UNION ALL SELECT 461 UNION ALL SELECT 462 UNION ALL SELECT 463 UNION ALL SELECT 464 UNION ALL SELECT 465 UNION ALL SELECT 466 UNION ALL SELECT 467 UNION ALL SELECT 468 UNION ALL SELECT 469 UNION ALL SELECT 470 UNION ALL SELECT 471 UNION ALL SELECT 472 UNION ALL SELECT 473 UNION ALL SELECT 474 UNION ALL SELECT 475 UNION ALL SELECT 476 UNION ALL SELECT 477 UNION ALL SELECT 478 UNION ALL SELECT 479 UNION ALL SELECT 480 UNION ALL SELECT 481 UNION ALL SELECT 482 UNION ALL SELECT 483 UNION ALL SELECT 484 UNION ALL SELECT 485 UNION ALL SELECT 486 UNION ALL SELECT 487 UNION ALL SELECT 488 UNION ALL SELECT 489 UNION ALL SELECT 490 UNION ALL SELECT 491 UNION ALL SELECT 492 UNION ALL SELECT 493 UNION ALL SELECT 494 UNION ALL SELECT 495 UNION ALL SELECT 496 UNION ALL SELECT 497 UNION ALL SELECT 498 UNION ALL SELECT 499 UNION ALL SELECT 500 UNION ALL 
SELECT 501 UNION ALL SELECT 502 UNION ALL SELECT 503 UNION ALL SELECT 504 UNION ALL SELECT 505 UNION ALL SELECT 506 UNION ALL SELECT 507 UNION ALL SELECT 508 UNION ALL SELECT 509 UNION ALL SELECT 510 UNION ALL SELECT 511 UNION ALL SELECT 512 UNION ALL SELECT 513 UNION ALL SELECT 514 UNION ALL SELECT 515 UNION ALL SELECT 516 UNION ALL SELECT 517 UNION ALL SELECT 518 UNION ALL SELECT 519 UNION ALL SELECT 520 UNION ALL SELECT 521 UNION ALL SELECT 522 UNION ALL SELECT 523 UNION ALL SELECT 524 UNION ALL SELECT 525 UNION ALL SELECT 526 UNION ALL SELECT 527 UNION ALL SELECT 528 UNION ALL SELECT 529 UNION ALL SELECT 530 UNION ALL SELECT 531 UNION ALL SELECT 532 UNION ALL SELECT 533 UNION ALL SELECT 534 UNION ALL SELECT 535 UNION ALL SELECT 536 UNION ALL SELECT 537 UNION ALL SELECT 538 UNION ALL SELECT 539 UNION ALL SELECT 540 UNION ALL SELECT 541 UNION ALL SELECT 542 UNION ALL SELECT 543 UNION ALL SELECT 544 UNION ALL SELECT 545 UNION ALL SELECT 546 UNION ALL SELECT 547 UNION ALL SELECT 548 UNION ALL SELECT 549 UNION ALL SELECT 550 UNION ALL 
SELECT 551 UNION ALL SELECT 552 UNION ALL SELECT 553 UNION ALL SELECT 554 UNION ALL SELECT 555 UNION ALL SELECT 556 UNION ALL SELECT 557 UNION ALL SELECT 558 UNION ALL SELECT 559 UNION ALL SELECT 560 UNION ALL SELECT 561 UNION ALL SELECT 562 UNION ALL SELECT 563 UNION ALL SELECT 564 UNION ALL SELECT 565 UNION ALL SELECT 566 UNION ALL SELECT 567 UNION ALL SELECT 568 UNION ALL SELECT 569 UNION ALL SELECT 570 UNION ALL SELECT 571 UNION ALL SELECT 572 UNION ALL SELECT 573 UNION ALL SELECT 574 UNION ALL SELECT 575 UNION ALL SELECT 576 UNION ALL SELECT 577 UNION ALL SELECT 578 UNION ALL SELECT 579 UNION ALL SELECT 580 UNION ALL SELECT 581 UNION ALL SELECT 582 UNION ALL SELECT 583 UNION ALL SELECT 584 UNION ALL SELECT 585 UNION ALL SELECT 586 UNION ALL SELECT 587 UNION ALL SELECT 588 UNION ALL SELECT 589 UNION ALL SELECT 590 UNION ALL SELECT 591 UNION ALL SELECT 592 UNION ALL SELECT 593 UNION ALL SELECT 594 UNION ALL SELECT 595 UNION ALL SELECT 596 UNION ALL SELECT 597 UNION ALL SELECT 598 UNION ALL SELECT 599 UNION ALL SELECT 600 UNION ALL 
SELECT 601 UNION ALL SELECT 602 UNION ALL SELECT 603 UNION ALL SELECT 604 UNION ALL SELECT 605 UNION ALL SELECT 606 UNION ALL SELECT 607 UNION ALL SELECT 608 UNION ALL SELECT 609 UNION ALL SELECT 610 UNION ALL SELECT 611 UNION ALL SELECT 612 UNION ALL SELECT 613 UNION ALL SELECT 614 UNION ALL SELECT 615 UNION ALL SELECT 616 UNION ALL SELECT 617 UNION ALL SELECT 618 UNION ALL SELECT 619 UNION ALL SELECT 620 UNION ALL SELECT 621 UNION ALL SELECT 622 UNION ALL SELECT 623 UNION ALL SELECT 624 UNION ALL SELECT 625 UNION ALL SELECT 626 UNION ALL SELECT 627 UNION ALL SELECT 628 UNION ALL SELECT 629 UNION ALL SELECT 630 UNION ALL SELECT 631 UNION ALL SELECT 632 UNION ALL SELECT 633 UNION ALL SELECT 634 UNION ALL SELECT 635 UNION ALL SELECT 636 UNION ALL SELECT 637 UNION ALL SELECT 638 UNION ALL SELECT 639 UNION ALL SELECT 640 UNION ALL SELECT 641 UNION ALL SELECT 642 UNION ALL SELECT 643 UNION ALL SELECT 644 UNION ALL SELECT 645 UNION ALL SELECT 646 UNION ALL SELECT 647 UNION ALL SELECT 648 UNION ALL SELECT 649 UNION ALL SELECT 650 UNION ALL 
SELECT 651 UNION ALL SELECT 652 UNION ALL SELECT 653 UNION ALL SELECT 654 UNION ALL SELECT 655 UNION ALL SELECT 656 UNION ALL SELECT 657 UNION ALL SELECT 658 UNION ALL SELECT 659 UNION ALL SELECT 660 UNION ALL SELECT 661 UNION ALL SELECT 662 UNION ALL SELECT 663 UNION ALL SELECT 664 UNION ALL SELECT 665 UNION ALL SELECT 666 UNION ALL SELECT 667 UNION ALL SELECT 668 UNION ALL SELECT 669 UNION ALL SELECT 670 UNION ALL SELECT 671 UNION ALL SELECT 672 UNION ALL SELECT 673 UNION ALL SELECT 674 UNION ALL SELECT 675 UNION ALL SELECT 676 UNION ALL SELECT 677 UNION ALL SELECT 678 UNION ALL SELECT 679 UNION ALL SELECT 680 UNION ALL SELECT 681 UNION ALL SELECT 682 UNION ALL SELECT 683 UNION ALL SELECT 684 UNION ALL SELECT 685 UNION ALL SELECT 686 UNION ALL SELECT 687 UNION ALL SELECT 688 UNION ALL SELECT 689 UNION ALL SELECT 690 UNION ALL SELECT 691 UNION ALL SELECT 692 UNION ALL SELECT 693 UNION ALL SELECT 694 UNION ALL SELECT 695 UNION ALL SELECT 696 UNION ALL SELECT 697 UNION ALL SELECT 698 UNION ALL SELECT 699 UNION ALL SELECT 700 UNION ALL 
SELECT 701 UNION ALL SELECT 702 UNION ALL SELECT 703 UNION ALL SELECT 704 UNION ALL SELECT 705 UNION ALL SELECT 706 UNION ALL SELECT 707 UNION ALL SELECT 708 UNION ALL SELECT 709 UNION ALL SELECT 710 UNION ALL SELECT 711 UNION ALL SELECT 712 UNION ALL SELECT 713 UNION ALL SELECT 714 UNION ALL SELECT 715 UNION ALL SELECT 716 UNION ALL SELECT 717 UNION ALL SELECT 718 UNION ALL SELECT 719 UNION ALL SELECT 720 UNION ALL SELECT 721 UNION ALL SELECT 722 UNION ALL SELECT 723 UNION ALL SELECT 724 UNION ALL SELECT 725 UNION ALL SELECT 726 UNION ALL SELECT 727 UNION ALL SELECT 728 UNION ALL SELECT 729 UNION ALL SELECT 730 UNION ALL SELECT 731 UNION ALL SELECT 732 UNION ALL SELECT 733 UNION ALL SELECT 734 UNION ALL SELECT 735 UNION ALL SELECT 736 UNION ALL SELECT 737 UNION ALL SELECT 738 UNION ALL SELECT 739 UNION ALL SELECT 740 UNION ALL SELECT 741 UNION ALL SELECT 742 UNION ALL SELECT 743 UNION ALL SELECT 744 UNION ALL SELECT 745 UNION ALL SELECT 746 UNION ALL SELECT 747 UNION ALL SELECT 748 UNION ALL SELECT 749 UNION ALL SELECT 750 UNION ALL 
SELECT 751 UNION ALL SELECT 752 UNION ALL SELECT 753 UNION ALL SELECT 754 UNION ALL SELECT 755 UNION ALL SELECT 756 UNION ALL SELECT 757 UNION ALL SELECT 758 UNION ALL SELECT 759 UNION ALL SELECT 760 UNION ALL SELECT 761 UNION ALL SELECT 762 UNION ALL SELECT 763 UNION ALL SELECT 764 UNION ALL SELECT 765 UNION ALL SELECT 766 UNION ALL SELECT 767 UNION ALL SELECT 768 UNION ALL SELECT 769 UNION ALL SELECT 770 UNION ALL SELECT 771 UNION ALL SELECT 772 UNION ALL SELECT 773 UNION ALL SELECT 774 UNION ALL SELECT 775 UNION ALL SELECT 776 UNION ALL SELECT 777 UNION ALL SELECT 778 UNION ALL SELECT 779 UNION ALL SELECT 780 UNION ALL SELECT 781 UNION ALL SELECT 782 UNION ALL SELECT 783 UNION ALL SELECT 784 UNION ALL SELECT 785 UNION ALL SELECT 786 UNION ALL SELECT 787 UNION ALL SELECT 788 UNION ALL SELECT 789 UNION ALL SELECT 790 UNION ALL SELECT 791 UNION ALL SELECT 792 UNION ALL SELECT 793 UNION ALL SELECT 794 UNION ALL SELECT 795 UNION ALL SELECT 796 UNION ALL SELECT 797 UNION ALL SELECT 798 UNION ALL SELECT 799 UNION ALL SELECT 800 UNION ALL 
SELECT 801 UNION ALL SELECT 802 UNION ALL SELECT 803 UNION ALL SELECT 804 UNION ALL SELECT 805 UNION ALL SELECT 806 UNION ALL SELECT 807 UNION ALL SELECT 808 UNION ALL SELECT 809 UNION ALL SELECT 810 UNION ALL SELECT 811 UNION ALL SELECT 812 UNION ALL SELECT 813 UNION ALL SELECT 814 UNION ALL SELECT 815 UNION ALL SELECT 816 UNION ALL SELECT 817 UNION ALL SELECT 818 UNION ALL SELECT 819 UNION ALL SELECT 820 UNION ALL SELECT 821 UNION ALL SELECT 822 UNION ALL SELECT 823 UNION ALL SELECT 824 UNION ALL SELECT 825 UNION ALL SELECT 826 UNION ALL SELECT 827 UNION ALL SELECT 828 UNION ALL SELECT 829 UNION ALL SELECT 830 UNION ALL SELECT 831 UNION ALL SELECT 832 UNION ALL SELECT 833 UNION ALL SELECT 834 UNION ALL SELECT 835 UNION ALL SELECT 836 UNION ALL SELECT 837 UNION ALL SELECT 838 UNION ALL SELECT 839 UNION ALL SELECT 840 UNION ALL SELECT 841 UNION ALL SELECT 842 UNION ALL SELECT 843 UNION ALL SELECT 844 UNION ALL SELECT 845 UNION ALL SELECT 846 UNION ALL SELECT 847 UNION ALL SELECT 848 UNION ALL SELECT 849 UNION ALL SELECT 850 UNION ALL 
SELECT 851 UNION ALL SELECT 852 UNION ALL SELECT 853 UNION ALL SELECT 854 UNION ALL SELECT 855 UNION ALL SELECT 856 UNION ALL SELECT 857 UNION ALL SELECT 858 UNION ALL SELECT 859 UNION ALL SELECT 860 UNION ALL SELECT 861 UNION ALL SELECT 862 UNION ALL SELECT 863 UNION ALL SELECT 864 UNION ALL SELECT 865 UNION ALL SELECT 866 UNION ALL SELECT 867 UNION ALL SELECT 868 UNION ALL SELECT 869 UNION ALL SELECT 870 UNION ALL SELECT 871 UNION ALL SELECT 872 UNION ALL SELECT 873 UNION ALL SELECT 874 UNION ALL SELECT 875 UNION ALL SELECT 876 UNION ALL SELECT 877 UNION ALL SELECT 878 UNION ALL SELECT 879 UNION ALL SELECT 880 UNION ALL SELECT 881 UNION ALL SELECT 882 UNION ALL SELECT 883 UNION ALL SELECT 884 UNION ALL SELECT 885 UNION ALL SELECT 886 UNION ALL SELECT 887 UNION ALL SELECT 888 UNION ALL SELECT 889 UNION ALL SELECT 890 UNION ALL SELECT 891 UNION ALL SELECT 892 UNION ALL SELECT 893 UNION ALL SELECT 894 UNION ALL SELECT 895 UNION ALL SELECT 896 UNION ALL SELECT 897 UNION ALL SELECT 898 UNION ALL SELECT 899 UNION ALL SELECT 900 UNION ALL 
SELECT 901 UNION ALL SELECT 902 UNION ALL SELECT 903 UNION ALL SELECT 904 UNION ALL SELECT 905 UNION ALL SELECT 906 UNION ALL SELECT 907 UNION ALL SELECT 908 UNION ALL SELECT 909 UNION ALL SELECT 910 UNION ALL SELECT 911 UNION ALL SELECT 912 UNION ALL SELECT 913 UNION ALL SELECT 914 UNION ALL SELECT 915 UNION ALL SELECT 916 UNION ALL SELECT 917 UNION ALL SELECT 918 UNION ALL SELECT 919 UNION ALL SELECT 920 UNION ALL SELECT 921 UNION ALL SELECT 922 UNION ALL SELECT 923 UNION ALL SELECT 924 UNION ALL SELECT 925 UNION ALL SELECT 926 UNION ALL SELECT 927 UNION ALL SELECT 928 UNION ALL SELECT 929 UNION ALL SELECT 930 UNION ALL SELECT 931 UNION ALL SELECT 932 UNION ALL SELECT 933 UNION ALL SELECT 934 UNION ALL SELECT 935 UNION ALL SELECT 936 UNION ALL SELECT 937 UNION ALL SELECT 938 UNION ALL SELECT 939 UNION ALL SELECT 940 UNION ALL SELECT 941 UNION ALL SELECT 942 UNION ALL SELECT 943 UNION ALL SELECT 944 UNION ALL SELECT 945 UNION ALL SELECT 946 UNION ALL SELECT 947 UNION ALL SELECT 948 UNION ALL SELECT 949 UNION ALL SELECT 950 UNION ALL 
SELECT 951 UNION ALL SELECT 952 UNION ALL SELECT 953 UNION ALL SELECT 954 UNION ALL SELECT 955 UNION ALL SELECT 956 UNION ALL SELECT 957 UNION ALL SELECT 958 UNION ALL SELECT 959 UNION ALL SELECT 960 UNION ALL SELECT 961 UNION ALL SELECT 962 UNION ALL SELECT 963 UNION ALL SELECT 964 UNION ALL SELECT 965 UNION ALL SELECT 966 UNION ALL SELECT 967 UNION ALL SELECT 968 UNION ALL SELECT 969 UNION ALL SELECT 970 UNION ALL SELECT 971 UNION ALL SELECT 972 UNION ALL SELECT 973 UNION ALL SELECT 974 UNION ALL SELECT 975 UNION ALL SELECT 976 UNION ALL SELECT 977 UNION ALL SELECT 978 UNION ALL SELECT 979 UNION ALL SELECT 980 UNION ALL SELECT 981 UNION ALL SELECT 982 UNION ALL SELECT 983 UNION ALL SELECT 984 UNION ALL SELECT 985 UNION ALL SELECT 986 UNION ALL SELECT 987 UNION ALL SELECT 988 UNION ALL SELECT 989 UNION ALL SELECT 990 UNION ALL SELECT 991 UNION ALL SELECT 992 UNION ALL SELECT 993 UNION ALL SELECT 994 UNION ALL SELECT 995 UNION ALL SELECT 996 UNION ALL SELECT 997 UNION ALL SELECT 998 UNION ALL SELECT 999 UNION ALL SELECT 1000 UNION ALL 
SELECT 1001

SELECT * FROM @Test

Or use CTE to insert.

DECLARE @Test AS table (c1 int)
;WITH CTE (c1) AS
(
    SELECT V.v 
    FROM 
    (
        VALUES
            (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(15),(16),(17),(18),(19),(20),(21),(22),(23),(24),(25),(26),(27),(28),(29),(30),(31),(32),(33),(34),(35),(36),(37),(38),(39),(40),(41),(42),(43),(44),(45),(46),(47),(48),(49),(50),
            (51),(52),(53),(54),(55),(56),(57),(58),(59),(60),(61),(62),(63),(64),(65),(66),(67),(68),(69),(70),(71),(72),(73),(74),(75),(76),(77),(78),(79),(80),(81),(82),(83),(84),(85),(86),(87),(88),(89),(90),(91),(92),(93),(94),(95),(96),(97),(98),(99),(100),
            (101),(102),(103),(104),(105),(106),(107),(108),(109),(110),(111),(112),(113),(114),(115),(116),(117),(118),(119),(120),(121),(122),(123),(124),(125),(126),(127),(128),(129),(130),(131),(132),(133),(134),(135),(136),(137),(138),(139),(140),(141),(142),(143),(144),(145),(146),(147),(148),(149),(150),
            (151),(152),(153),(154),(155),(156),(157),(158),(159),(160),(161),(162),(163),(164),(165),(166),(167),(168),(169),(170),(171),(172),(173),(174),(175),(176),(177),(178),(179),(180),(181),(182),(183),(184),(185),(186),(187),(188),(189),(190),(191),(192),(193),(194),(195),(196),(197),(198),(199),(200),
            (201),(202),(203),(204),(205),(206),(207),(208),(209),(210),(211),(212),(213),(214),(215),(216),(217),(218),(219),(220),(221),(222),(223),(224),(225),(226),(227),(228),(229),(230),(231),(232),(233),(234),(235),(236),(237),(238),(239),(240),(241),(242),(243),(244),(245),(246),(247),(248),(249),(250),
            (251),(252),(253),(254),(255),(256),(257),(258),(259),(260),(261),(262),(263),(264),(265),(266),(267),(268),(269),(270),(271),(272),(273),(274),(275),(276),(277),(278),(279),(280),(281),(282),(283),(284),(285),(286),(287),(288),(289),(290),(291),(292),(293),(294),(295),(296),(297),(298),(299),(300),
            (301),(302),(303),(304),(305),(306),(307),(308),(309),(310),(311),(312),(313),(314),(315),(316),(317),(318),(319),(320),(321),(322),(323),(324),(325),(326),(327),(328),(329),(330),(331),(332),(333),(334),(335),(336),(337),(338),(339),(340),(341),(342),(343),(344),(345),(346),(347),(348),(349),(350),
            (351),(352),(353),(354),(355),(356),(357),(358),(359),(360),(361),(362),(363),(364),(365),(366),(367),(368),(369),(370),(371),(372),(373),(374),(375),(376),(377),(378),(379),(380),(381),(382),(383),(384),(385),(386),(387),(388),(389),(390),(391),(392),(393),(394),(395),(396),(397),(398),(399),(400),
            (401),(402),(403),(404),(405),(406),(407),(408),(409),(410),(411),(412),(413),(414),(415),(416),(417),(418),(419),(420),(421),(422),(423),(424),(425),(426),(427),(428),(429),(430),(431),(432),(433),(434),(435),(436),(437),(438),(439),(440),(441),(442),(443),(444),(445),(446),(447),(448),(449),(450),
            (451),(452),(453),(454),(455),(456),(457),(458),(459),(460),(461),(462),(463),(464),(465),(466),(467),(468),(469),(470),(471),(472),(473),(474),(475),(476),(477),(478),(479),(480),(481),(482),(483),(484),(485),(486),(487),(488),(489),(490),(491),(492),(493),(494),(495),(496),(497),(498),(499),(500),
            (501),(502),(503),(504),(505),(506),(507),(508),(509),(510),(511),(512),(513),(514),(515),(516),(517),(518),(519),(520),(521),(522),(523),(524),(525),(526),(527),(528),(529),(530),(531),(532),(533),(534),(535),(536),(537),(538),(539),(540),(541),(542),(543),(544),(545),(546),(547),(548),(549),(550),
            (551),(552),(553),(554),(555),(556),(557),(558),(559),(560),(561),(562),(563),(564),(565),(566),(567),(568),(569),(570),(571),(572),(573),(574),(575),(576),(577),(578),(579),(580),(581),(582),(583),(584),(585),(586),(587),(588),(589),(590),(591),(592),(593),(594),(595),(596),(597),(598),(599),(600),
            (601),(602),(603),(604),(605),(606),(607),(608),(609),(610),(611),(612),(613),(614),(615),(616),(617),(618),(619),(620),(621),(622),(623),(624),(625),(626),(627),(628),(629),(630),(631),(632),(633),(634),(635),(636),(637),(638),(639),(640),(641),(642),(643),(644),(645),(646),(647),(648),(649),(650),
            (651),(652),(653),(654),(655),(656),(657),(658),(659),(660),(661),(662),(663),(664),(665),(666),(667),(668),(669),(670),(671),(672),(673),(674),(675),(676),(677),(678),(679),(680),(681),(682),(683),(684),(685),(686),(687),(688),(689),(690),(691),(692),(693),(694),(695),(696),(697),(698),(699),(700),
            (701),(702),(703),(704),(705),(706),(707),(708),(709),(710),(711),(712),(713),(714),(715),(716),(717),(718),(719),(720),(721),(722),(723),(724),(725),(726),(727),(728),(729),(730),(731),(732),(733),(734),(735),(736),(737),(738),(739),(740),(741),(742),(743),(744),(745),(746),(747),(748),(749),(750),
            (751),(752),(753),(754),(755),(756),(757),(758),(759),(760),(761),(762),(763),(764),(765),(766),(767),(768),(769),(770),(771),(772),(773),(774),(775),(776),(777),(778),(779),(780),(781),(782),(783),(784),(785),(786),(787),(788),(789),(790),(791),(792),(793),(794),(795),(796),(797),(798),(799),(800),
            (801),(802),(803),(804),(805),(806),(807),(808),(809),(810),(811),(812),(813),(814),(815),(816),(817),(818),(819),(820),(821),(822),(823),(824),(825),(826),(827),(828),(829),(830),(831),(832),(833),(834),(835),(836),(837),(838),(839),(840),(841),(842),(843),(844),(845),(846),(847),(848),(849),(850),
            (851),(852),(853),(854),(855),(856),(857),(858),(859),(860),(861),(862),(863),(864),(865),(866),(867),(868),(869),(870),(871),(872),(873),(874),(875),(876),(877),(878),(879),(880),(881),(882),(883),(884),(885),(886),(887),(888),(889),(890),(891),(892),(893),(894),(895),(896),(897),(898),(899),(900),
            (901),(902),(903),(904),(905),(906),(907),(908),(909),(910),(911),(912),(913),(914),(915),(916),(917),(918),(919),(920),(921),(922),(923),(924),(925),(926),(927),(928),(929),(930),(931),(932),(933),(934),(935),(936),(937),(938),(939),(940),(941),(942),(943),(944),(945),(946),(947),(948),(949),(950),
            (951),(952),(953),(954),(955),(956),(957),(958),(959),(960),(961),(962),(963),(964),(965),(966),(967),(968),(969),(970),(971),(972),(973),(974),(975),(976),(977),(978),(979),(980),(981),(982),(983),(984),(985),(986),(987),(988),(989),(990),(991),(992),(993),(994),(995),(996),(997),(998),(999),(1000),
            (1001)
    ) AS V(v)
)
INSERT @Test (c1)
SELECT c1 FROM CTE

SELECT * FROM @Test