Solved

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

Posted on 2009-07-07
5
261 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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
PERFORMANCE OF SQL QUERY 13 77
Error in SSIS while executing  - Potential data loss 4 34
SQL Error - Query 6 49
SSRS 2013 - Finding Datasets/StoredProcedures 4 32
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
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…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

680 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