Microsof SQL Server Management Studio 2017 programını kullanıyorum.
Bir Veritabanım var ve ona sql koduyla tablo oluşturup alanlarına bilgileri atmak istiyorum ancak kodu çalıştırdığımda:
Msg 10738, Level 15, State 1, Line 1011
The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values.
hatasını alıyorum
sql kodu:
CREATE TABLE urunResimGrup (
"id" int NOT NULL,
"urun_id" int DEFAULT NULL,
"urunResim" varchar(100) DEFAULT NULL,
"sayi" int DEFAULT NULL,
"urun_idG" int DEFAULT NULL
)
INSERT INTO urunResimGrup ("id", "urun_id", "urunResim", "sayi", "urun_idG") VALUES
(586, 2276, '1231.jpg', 0, 2276),
(631, 332, 'e79c16cb41353c9c32b0.jpg', 1, 0),
(632, 332, '9e87586668eb45e36d5d.jpg', 2, 0),
(633, 333, 'beaf6672bb1081272c2d.jpg', 1, 0),
(634, 333, 'f8565f02d9cb6c272408.jpg', 2, 0),
(717, 1530, '5142.jpg', 0, 1530),
(1476, 539, '7e3d06281448099c960b.jpg', 1, 0),
(1477, 539, 'e2de4127bb68f338310f.jpg', 2, 0),
(1478, 539, '485e77280181d1b6ed01.jpg', 3, 0),
(1479, 539, 'ff7f0548a259eabc8598.jpg', 4, 0),
(1484, 536, '3a0e61795ffbdb59d3b1.jpg', 1, 0),
(1485, 536, '45d0ad65c424336cf378.jpg', 2, 0),
(1486, 536, '0bb2473753438d38832b.jpg', 3, 0),
(1487, 536, '8464a96e3d38df0b7667.jpg', 4, 0),
(1489, 537, '29f35a0759233a430ee2.jpg', 1, 0),
(1490, 537, 'c0582e2702d191d73cbc.jpg', 2, 0),
(1491, 537, 'f75652251b48f9f2766a.jpg', 3, 0),
(1492, 537, 'cefd4a092131fa7c6791.jpg', 4, 0),
(1493, 533, '1a988ebb86c1d60f5d27.jpg', 1, 0),
(1494, 533, '48a32d5db176ea92e8ba.jpg', 2, 0),
(1495, 533, '667d644299e08210f4f1.jpg', 3, 0),
(1496, 533, '0e0bb641912fa3144316.jpg', 4, 0),
(1497, 532, '9fadf4dc325ec3c743ab.jpg', 1, 0),
(1498, 532, '3daac3c49b38d4f7de39.jpg', 2, 0),
(1499, 532, 'cb01b95bd652ed6c628d.jpg', 3, 0),
(1500, 532, 'be0b8a6c21a561493653.jpg', 4, 0),
(1501, 677, '82f259a06c25640a2c26.jpg', 1, 0),
(1502, 677, '7094da1cc24ba82493cf.jpg', 2, 0),
(1503, 677, 'bdc43e3655ecbb077cc6.jpg', 3, 0),
(1504, 677, 'b25ced545d0884b9e753.jpg', 4, 0),
(1505, 678, 'c3e5a7eb307f659d05bf.jpg', 1, 0),
(1506, 678, '93a773b35a89ba81b91d.jpg', 2, 0),
(1507, 678, '079631712be4822ce75f.jpg', 3, 0),
(1508, 678, '1ba37972acc1be946363.jpg', 4, 0),
(1509, 679, '2ac3351e68ec04dfe835.jpg', 1, 0),
(1510, 679, '1fb3139b099691ea92d9.jpg', 2, 0),
(1511, 679, '6921e4af9726604156e0.jpg', 3, 0),
(1512, 679, 'b6e1aeb78e1917e732ff.jpg', 4, 0),
(1513, 680, '9252f0dde0f0e3066e08.jpg', 1, 0),
(1514, 680, 'c4d30db4a3057473c951.jpg', 2, 0),
(1515, 680, 'd29152b3b75bdb0a8b34.jpg', 3, 0),
(1516, 680, '6bdfdaa6f3b705a03d93.jpg', 4, 0),
(1521, 682, '4b35b57097b0f7e150c3.jpg', 1, 0),
(1522, 682, '874dc99b9236a5816de4.jpg', 2, 0),
(1523, 682, 'd1213ce4dda8173676d3.jpg', 3, 0),
(1524, 682, 'fa856f359424ac7657c0.jpg', 4, 0),
(1525, 530, '79ef2cd853ed4950a3dc.jpg', 1, 0),
(1526, 530, '9734ac683151ed7cf4ec.jpg', 2, 0),
(1527, 530, 'eb8d0a19af90e6181e9b.jpg', 3, 0),
(1531, 683, '637e8a4752c00fc1c563.jpg', 1, 0),
(1532, 683, 'fda3bf2aa29bad70a7cd.jpg', 2, 0),
(1533, 683, 'd44de17fd55167f3dbaa.jpg', 3, 0),
(1534, 528, 'b2dbbd94445e6d1794bb.jpg', 1, 0),
(1535, 528, '9a677092a820b81116e1.jpg', 2, 0),
(1536, 528, 'd7d54808d5b260fb4945.jpg', 3, 0),
(1537, 528, 'f6e09e84cb463489f342.jpg', 4, 0),
(1538, 529, 'e102f14bac1d5419a098.jpg', 1, 0),
(1539, 529, '515cf7dbce22159cac0d.jpg', 2, 0),
(1540, 529, '18ef9365f1e720e9007d.jpg', 3, 0),
(1541, 529, '9b984b11dc279e18aa13.jpg', 4, 0),
(1546, 685, '9b544c7e8c2c9f9a6e80.jpg', 1, 0),
(1547, 685, 'f5f9f47ee7baac941888.jpg', 2, 0),
(1548, 685, '929fb023c5cdfb8b0761.jpg', 3, 0),
(1549, 685, 'e750d2cd540e41e4d215.jpg', 4, 0),
(1550, 535, 'ac1a4f009e62375ebbf6.jpg', 1, 0),
.
.
. diye devam ediyor
acaba çözümü nedir ?
