Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


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

Posted on 2009-07-07
Medium Priority
Last Modified: 2012-05-07

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...

Question by:ThanksWelcome
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 17

Expert Comment

ID: 24799466
You Can use the INSERT Statement to insert records. Here is a reference for syntax and examples:
LVL 17

Assisted Solution

pssandhu earned 400 total points
ID: 24799486
This will get you started with using SQL Managment Studio:
LVL 20

Accepted Solution

ddayx10 earned 1600 total points
ID: 24799526
You can just right click on the table in question and select "Open Table" and just add a new record.


Click the NewQuery button and type in your SQL INSERT syntax right there...

Author Comment

ID: 24799548
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!

Author Closing Comment

ID: 31600889

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question