Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Gekko
Yak Posting Veteran
63 Posts |
 Posted - 2012-01-24 : 10:46:41
|
| HalloI create table, and insert values.:CREATE TABLE dbo.Data ( Item1 VARCHAR(20) NOT NULL, Item2 VARCHAR(20) NOT NULL )INSERT dbo.Data ( Item1, Item2 )VALUES ('132529','210111'), (1 row)('132529','2101111'), (2 row)('132529','303034') (3 row)but this values I have 15 000 rows.It is possible only 1000 rows. (now)What I use query on insert 15 000 rows?thanks |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-01-24 : 10:49:23
|
do it 15 times?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Gekko
Yak Posting Veteran
63 Posts |
Posted - 2012-01-24 : 11:05:34
|
| I think itIt is also a solutionthanks |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-01-24 : 11:10:59
|
While we don't know where the data is coming from (and I don't believe you are typing the data via keyboard) it is not possible to give any better solution.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2012-01-24 : 12:29:11
|
| Seems unlikely that you have the data in that format already?So use BCP to get the data from file perhaps? or SSIS ... or XML even |
|
|
|
|
|
|
insert over 1 000 rows....error