need help on this write 400–600 words that respond to the following questions wi

Question

need help on this write 400–600 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas: There is more than one method used to create and manage tables within databases using SQL server. Research two methods used to accomplish the above task and compare them and answer the following questions:

•Which of the two methods would you select to use? •

What would be the reasons for your selection?

Explanation / Answer

Two methods used to create and manage tables within databases using SQL server

In this scenario we discuss two different methods can be used to manage SQL Server are as below:

The GUI method:

From the Windows Start Menu, select “Microsoft SQL Server”, and then “SQL Server Management Studio”. Once the Management Studio starts right click the Databases folder from “Solution Explorer” right click and select new Database from the list. Enter a name in the “Database name” text box.

Now we have to create the table, to create a Table, right click and expand the Databases folder, and then right-click and expand the newly created “Test” database. Then right click on “Tables” and select “New Table”, you will be prompted to fill in “Column Name” and “Data Type”.

Save the Table by clicking the “Save” icon on the top menu bar.

To enter data into the newly created table, expand the Tables folder from the left menu in solution explorer.

The newly created table will be listed. Right-click on it and select “Open Table”. A small grid will open. Enter a few data lines into the grid. Moving to a new line after entering data automatically saves.

Command line method:

Select “New Query” from the top left menu bar in the SQL Server Management Studio.

A dialog box will pop up asking what server to connect to. Enter your server name and then click connect. A drop down box above the new window determines which database you are working with, leave the default of “master”. This is SQL Server’s main system database.

When working with a command or query window, the language used by SQL Server is TSQL.

Create a new database called Test2 by entering the following TSQL query then pressing the “Execute” button on the top menu bar.

CREATE DATABASE Test2;

The Messages window on the bottom of the screen should say “Command(s) completed successfully.”

Now type USE Test2;

Again press execute. This tells the Query window to run any future commands against the newly created Test2 database rather than against master.

Next, we’ll create a “Sample” table to hold data. Delete any TSQL in the Query from query window and execute the following:

In order to enter data into the newly created table, we have to execute the following statement.

In this, we have used both the Graphical User Interface and TSQL command line queries to create a new Database and a new Table.

Values were inserted into the new table and then retrieved. If your SQL Server was installed using defaults, then our examples just created are stored on your hard drive under c:program files Microsoft SQL Server MSSQL Data. There should be a Test.mdf (the actual data), and Test.ldf (a transaction log of the changes we made to test).

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.