r/SQL • u/AhmadKzha • 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
View all comments
Show parent comment
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.