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 |
|
jrobin747
Starting Member
48 Posts |
 Posted - 2013-08-29 : 11:05:55
|
| I want to add record to a table not using a query.I did it before but I'm having trouble doing it again.I know to right click on the table nameedit top 200 rowsAfter that I don't remember how to add a new row so that I can enter data. |
|
|
MuMu88
Aged Yak Warrior
549 Posts |
Posted - 2013-08-29 : 12:06:53
|
| if you scroll all the way to the bottom, you should see a row full of null values, that is where you can insert what you want.orYou can generate a script to insert byclicking "Script Table as" then "Insert To" option. |
 |
|
|
jrobin747
Starting Member
48 Posts |
Posted - 2013-08-29 : 12:26:20
|
| Thanks |
|
|
|
|
|
|
Adding data to table SQL Server Management Studio