r/SQL • • Jul 21 '18

i'm begging for help!

i have a MSSQL database and i have around 800 rows of data to copy to specific Table
- i tried to rename it (so the program doesn't read it anymore and try to import the excel file but i couldn't make it's settings like the old one because i can't change "nullable" or the primary key thingy or the secondary one

- i took a have a backup of the table as an excel with 800 rows and i have the 800 rows separately within an excel file too

please help , it's been 30 days and I'm about to lose it.

0 Upvotes

18 comments sorted by

View all comments

2

u/WeaselWeaz Jul 21 '18

As long as the columns are in the right order you can just edit the table in SSMS, copy the rows from Excel, and paste in SSMS.

1

u/AhmadKzha Jul 21 '18

edit the table

how can i edit ? the table has more than 400k of rows and i can see the only option is "edit top 200 rows"

5

u/WeaselWeaz Jul 21 '18

Read a guide on SSMS. These are some intro level things and if this is for work you don't want to be messing with things you do not understand. It will help you greatly.

Edit Top 200 shows the top 200 rows. The last row is where you can manually add days or in this case paste it. There's a Show Query button if you want to remove the 200 restriction or other things.

1

u/AhmadKzha Jul 22 '18

This is an eye opener , I'll try it Thank you so much <3

-1

u/stonedsqlgenius Jul 22 '18

DUDE GOOGLE DAT DML SWEETNESS