stupid question in sql server studio..please reply

[abdoks]

Hello guys

i have a very stupid question in sql server management studio ,but please i need an answer :

what should i do to put missing lines in a table? ,
For example:i want to put those lines for jupiter in RefRegion table..

24009    201    93    JUPITER    ???? ?? ??    1    3001    -1    0    0    ***    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL

24010    202    93    JUPITER    ???? ?? ??    1    3001    -1    0    0    ***    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL

Thanks and please Reply ^^

[zikor1337]

@up:

24009 201 93 JUPITER ???? ?? ?? 1 3001 -1 0 0 *** NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
24010 202 93 JUPITER ???? ?? ?? 1 3001 -1 0 0 *** NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

Try copy/paste that into your RefRegion .

The things are pretty simple. To copy/paste some lines into your table do this: instead of the spaces between the data put a "tab space" .

I have no ******* idea if you get what I am saying ... but inserting them manually ... gosh! NO, NO, NO! It would take days!

[abdoks]

Originally Posted by zikor1337

@up:




Try copy/paste that into your RefRegion .

The things are pretty simple. To copy/paste some lines into your table do this: instead of the spaces between the data put a "tab space" .

I have no ******* idea if you get what I am saying ... but inserting them manually ... gosh! NO, NO, NO! It would take days!

bro that's the problem i know that its impossible to put the lines manually cuz i have to put hundreds of lines....
well i dont get the "Tab Space" thing .... so it would be great if you can make photos about this thing as an example

i'm not a noob xD , i just don't know

[royalblade]

First, Select the line...and right click on it. PRess copy.

If you did this correctly, after pressing CTRL + V a line should pop up tha tu just copied.

24009    201    93    JUPITER    ???? ?? ??    1    3001    -1    0    0    ***    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL

Magic eh?

okay basically, go to the table, right click on the table press Modify or Edit or whatever the heck it says there. Then scroll down until the END of the table.
Then you select the NUMBER next to the row. its called a ROWNUMBER. u press on it and then you press CTRL + V.

Then you have that whole line inside it. :O :O :O :O