943,712 Members | Top Members by Rank

Ad:
  • MS SQL Discussion Thread
  • Unsolved
  • Views: 613
  • MS SQL RSS
Feb 23rd, 2009
0

SQL Express

Expand Post »
Hi,
I'm new to SQL Server. I just installed SQL Server 2008 Express. Then I opened Management Studio, right clicked on Database and created a new Database. Then I expanded Database, right clicked on Table and created a new Table. Now, my question is, how do I add data to the table I created?

Thanks
Similar Threads
Reputation Points: 8
Solved Threads: 0
Junior Poster
shers is offline Offline
112 posts
since Aug 2007
Feb 23rd, 2009
0

Re: SQL Express

right click on table then open table, write data row by row
or you can add data from application using ADO.NET
Featured Poster
Reputation Points: 480
Solved Threads: 276
Postaholic
Ramy Mahrous is offline Offline
2,189 posts
since Aug 2006
Feb 23rd, 2009
0

Re: SQL Express

Click to Expand / Collapse  Quote originally posted by shers ...
Hi,
I'm new to SQL Server. I just installed SQL Server 2008 Express. Then I opened Management Studio, right clicked on Database and created a new Database. Then I expanded Database, right clicked on Table and created a new Table. Now, my question is, how do I add data to the table I created?

Thanks
If you have any basic questions, most of them can be answered by reading SQL Server's Books Online at http://msdn.microsoft.com/en-us/library/ms130214.aspx. This is a must have for anyone working with MS SQL Server.

Also another great tip when using Management Studio is pressing F1 will take you directly to some information about the screen you are working in. Try this out, open up a new query by clicking on the button at the top right called "New Query" and type this code

MS SQL Syntax (Toggle Plain Text)
  1. SELECT * FROM TableA

The script probably will not run, unless you actually have a table called "TableA." But for our purposes of testing out the F1 function we can still use this script. Once you have written the code above into a new query window, highlight the word "SELECT" and press F1. A new window will pop up with information about the SELECT command. The same thing can be performed on the word "FROM" and the character "*" which is a wild card that means everything basically. Try it out.
Reputation Points: 12
Solved Threads: 6
Junior Poster
Geek-Master is offline Offline
156 posts
since Dec 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS SQL Forum Timeline: Remote MS SQL database update issue
Next Thread in MS SQL Forum Timeline: SQL LOGIC hELP





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC