Solved

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

Posted on 2009-07-07
5
237 Views
Last Modified: 2012-05-07
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!
0
Comment
Question by:ThanksWelcome
  • 2
  • 2
5 Comments
 
LVL 17

Expert Comment

by:pssandhu
ID: 24799466
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
 
LVL 17

Assisted Solution

by:pssandhu
pssandhu earned 100 total points
ID: 24799486
This will get you started with using SQL Managment Studio:
http://msdn.microsoft.com/en-us/library/bb934498.aspx
P.
0
 
LVL 20

Accepted Solution

by:
ddayx10 earned 400 total points
ID: 24799526
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
 

Author Comment

by:ThanksWelcome
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!
0
 

Author Closing Comment

by:ThanksWelcome
ID: 31600889
Thank's!
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

895 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now