Shulou(Shulou.com)06/01 Report--

Installation and basic Management of SQL server Database on server 2008R2 (1)

Select the mirror file of SQL's database

Double-click setup.ext to execute the installer

Select the installation item here, and select a new installation

All the installed environmental monitoring passed.

Because this is the image of the cracked version used, the key is automatically generated.

Check the installation environment again

Select the first item here

Select all the functions here

Select the default instance name here

Here, add the built-in account of the system to the service, NT

Select mixed authentication here and enter the password for sa. And add a local administrator

Add a local administrator account here

Select the first item

Start installation

SQL services can be started or shut down through the configuration Manager

Link the database through the SSMS management tool

Create a database of benet

Create a tabl

Here you choose to edit the first 200 rows to insert data

Select the new query to create the database on the command line

Create a database accp

Create a table in the form of commands

Query the contents of the entire table

Insert data into the table

Whether the query was inserted successfully

Set the major number as the primary key

Set an age constraint between 0 and 100

Set constraints for gender, you can only type male or female

Associate two tables and set foreign keys

Check whether the foreign key is set successfully. The primary key is × ×, and the foreign key is gray.

Then verify which rules are violated by the inserted data, which violates the age range, which can only be 0-100.

This is a violation of this one. There can be no repetition.

This violates the gender restriction and can only be imported as male or female.

This violates the limitation of citation and cannot refer to meta-ancestors that do not exist.

Multi-table query

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.