Making a table in SQL server for visual studio

Making a table in SQL server for visual studio


3: Give your sever name it mean computer name/SQL user name and then select SQL authentication and give your SQL password and username click on connect button.

figure 1-2%

5:After create new table right click on new table and and select design from that and then make column from there save and name your table and then refresh the table folder and right click on table and select edit top 200 rows and then give some rows to your column and then save or shout cut keys CTRL+S from your keyboard.

figure 1-3

figure 1-3

figure 1-3

6: After these steps right click on your database and then click on new query a new window will be open look like this one as shown in figure 1-3 then write the query in the windows SELECT * FROM TABLE(NAME)
First of all I will tell about this article and screen cast we will learn making a table for the visual studio to work on SQL Database for visual studio in this course we will use SQL for only website making purpose so the mean of writing this paragraph to understand the course we will do in these Articles
1: first of all and your first step will be the download the SQL server express its Free from MICROSOFT so go to the Microsoft site and download the SQL server express for free and Install it on your hard drive.
2: your next step will be to open the SQL server and when you open the SQL Server so an window will open on your screen look like this As shown in the figure 1-1

figure 1-1

4: A new widows will be open look like this one as shown in figure 1-2
so in the next step we will create A database so right click on database folder as shown in figure 1-2 and select create new database name your database whatever you want.
5: And in the next step we going to click on the database then right click the table and select new table from menu or watch Screen cast.

figure 1-3

6: After these steps right click on your database and then click on new query a new window will be open look like this one as shown in figure 1-3 then write the query in the windows SELECT * FROM TABLE(NAME)
For example SELECT * FROM STUDENT and then click on execute button.

previous:Making a table in SQL... NEXT:How can we connect SQL