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
right click on table then open table, write data row by row
or you can add data from application using ADO.NET
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
SELECT * FROM TableAThe 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.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.