A Tutorial About SQL Servers
SQL Server is a Microsoft technology used to incorporate database services. A database provides stored data in objects called "tables." The table data is queried and displayed using a database language called Structured Query Language (SQL). SQL Server provides you with the Management Studio software, which is the main console to maintain your web server. Some basic development understanding helps you get started with your SQL Server.
Instructions
Difficulty:
Step 1
Click "Start" > "All Programs" > "SQL Server" > "SQL Server Management Studio." This opens your main SQL Server console, which you use to create tables and stored procedures.
Step 2
Click "Connect" at the top of the left window. Enter your SQL Server name and the username and password for your server. This information is provided by your database administrator if you are on a company network. The connection is made and a list of options are shown in the left window panel.
Step 3
Right-click "Tables" and select "New." This opens a designer, which creates a new table on your SQL Server. Tables are the main components that store data. They are created as logical "parts" of a collection of data. For instance, a customer table records a list of customers for the business. Enter "First Name" into the first row in the designer and click "Save." Name it "Customer." This creates a new SQL Server table.
Step 4
Right-click "Programmability" and select "New Stored Procedure." Stored procedures are lines of code you can run on the server or in your application. Stored procedures edit the data in tables. Enter the following code into the console:
select * from customer
The code above retrieves records from the customer table you created in step 3. Click "Save" and enter a name for your stored procedure. Click "Run" in the main menu to execute the stored procedure. The data returned is shown in a graph at the bottom of the Management Studio window.
References
Article Written By Jim Campbell
Jim Campbell has been a computer engineer for over five years. He excels in hardware repair, computer programming and troubleshooting, and software design. He is currently attending Florida Atlantic University, pursuing a master's degree in computer and electrical engineering and fine-tuning his technical writing abilities.