How to add records to a sql server database from ms sql server management studio

Hi,

I am new to sql server and ms sql server management studio express.  I have a database and I would like to know if and how it is possible to add and manage records from ms sql server management studio express.  I can't find anything like this...

Thanks!
ThanksWelcomeAsked:
Who is Participating?
 
ddayx10Connect With a Mentor Commented:
You can just right click on the table in question and select "Open Table" and just add a new record.

OR

Click the NewQuery button and type in your SQL INSERT syntax right there...
0
 
pssandhuCommented:
You Can use the INSERT Statement to insert records. Here is a reference for syntax and examples:
http://msdn.microsoft.com/en-us/library/aa933206(SQL.80).aspx
P.
0
 
pssandhuConnect With a Mentor Commented:
This will get you started with using SQL Managment Studio:
http://msdn.microsoft.com/en-us/library/bb934498.aspx
P.
0
 
ThanksWelcomeAuthor Commented:
Yeeah!  Right click and open table:  just what I needed:  from there you have a grid where you can easily manage the records.

pssanhu, thanks for the refenrences, I will note this!
0
 
ThanksWelcomeAuthor Commented:
Thank's!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.