SQL Server database installation and basic management on server 2008r2

installation and basic management of SQL Server database on server 2008r2 (i)

Select the image file for the SQL database

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M01/95/CA/wKioL1kZqsSj1vpyAACWa-gx-YQ165.png "style=" float : none; "title=" 1.png "alt=" Wkiol1kzqssj1vpyaacwa-gx-yq165.png "/>

Double-click Setup.ext to execute the Setup program

650) this.width=650; "src=" https://s5.51cto.com/wyfs02/M02/95/CA/wKiom1kZqsfSR4xzAAav6Ha5N9w402.jpg "style=" float : none; "title=" 2.jpg "alt=" Wkiom1kzqsfsr4xzaaav6ha5n9w402.jpg "/>

650) this.width=650; "src=" https://s1.51cto.com/wyfs02/M02/95/CA/wKioL1kZqsnCaEoLAAVTSNQHf3E995.jpg "style=" float : none; "title=" 3.jpg "alt=" Wkiol1kzqsncaeolaavtsnqhf3e995.jpg "/>

Select the installation item here and select the new installation

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M00/95/CA/wKiom1kZqsqAjb3gAABbR6oSrbA592.png "style=" float : none; "title=" 4.png "alt=" Wkiom1kzqsqajb3gaabbr6osrba592.png "/>

Installation of environmental monitoring all through

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M01/95/CA/wKiom1kZqsuwkfIPAADLQAZuaCM277.png "style=" float : none; "title=" 5.png "alt=" Wkiom1kzqsuwkfipaadlqazuacm277.png "/>

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

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M01/95/CA/wKioL1kZqszwFmswAAB1XqPp5Fo842.png "style=" float : none; "title=" 6.png "alt=" Wkiol1kzqszwfmswaab1xqpp5fo842.png "/>

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M02/95/CA/wKiom1kZqszx9bJSAAByXfcnn3Y996.png "style=" float : none; "title=" 7.png "alt=" Wkiom1kzqszx9bjsaabyxfcnn3y996.png "/>

Testing the installation environment once again

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M00/95/CA/wKioL1kZqsyQrgaFAACnIV2iZJw353.png "style=" float : none; "title=" 8.png "alt=" Wkiol1kzqsyqrgafaacniv2izjw353.png "/>

Select the first item here

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M01/95/CA/wKiom1kZqs3AD-6_AAB0CVxpeb8040.png "style=" float : none; "title=" 9.png "alt=" Wkiom1kzqs3ad-6_aab0cvxpeb8040.png "/>

Select all the functions here

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M02/95/CA/wKioL1kZqs2R3L1FAACx1XNSKjU292.png "style=" float : none; "title=" 10.png "alt=" Wkiol1kzqs2r3l1faacx1xnskju292.png "/>

Choose the default instance name here

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M00/95/CA/wKiom1kZqs2TvhdzAACbz_lB3zk606.png "style=" float : none; "title=" 11.png "alt=" Wkiom1kzqs2tvhdzaacbz_lb3zk606.png "/>

This adds the system's built-in account to the service, NT

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M01/95/CA/wKioL1kZqs7BjTdqAADZihV82ho359.png "style=" float : none; "title=" 12.png "alt=" Wkiol1kzqs7bjtdqaadzihv82ho359.png "/>

Choose Hybrid authentication here and enter the sa password. and add the local administrator

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M00/95/CA/wKioL1kZqs6CTrRvAACD9AyPKbE124.png "style=" float : none; "title=" 13.png "alt=" Wkiol1kzqs6ctrrvaacd9aypkbe124.png "/>

Add a local administrator account here

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M02/95/CA/wKiom1kZqs7QlPvXAABIrRP5avY691.png "style=" float : none; "title=" 14.png "alt=" Wkiom1kzqs7qlpvxaabirrp5avy691.png "/>

Select the first item

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M01/95/CA/wKiom1kZqs_TAqcpAABksNVx8t4953.png "style=" float : none; "title=" 15.png "alt=" Wkiom1kzqs_taqcpaabksnvx8t4953.png "/>

Start installation

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M02/95/CA/wKioL1kZqs_zcRu0AABp0xtWvSE285.png "style=" float : none; "title=" 16.png "alt=" Wkiol1kzqs_zcru0aabp0xtwvse285.png "/>

Services that enable or disable SQL through Configuration Manager

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M00/95/CA/wKiom1kZqtDgJDgCAAB6eBkvn-k137.png "style=" float : none; "title=" 17.png "alt=" Wkiom1kzqtdgjdgcaab6ebkvn-k137.png "/>

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M00/95/CA/wKioL1kZqtDDthY0AABO2LavJ6E455.png "style=" float : none; "title=" 18.png "alt=" Wkiol1kzqtddthy0aabo2lavj6e455.png "/>

Link a database through the SSMS administration tool

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M01/95/CA/wKiom1kZqtGR6v0TAADtK1LBITY228.png "style=" float : none; "title=" 19.png "alt=" Wkiom1kzqtgr6v0taadtk1lbity228.png "/>

To create a Benet database

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M01/95/CA/wKioL1kZqtHhLtynAABZxMBxldk466.png "style=" float : none; "title=" 20.png "alt=" Wkiol1kzqthhltynaabzxmbxldk466.png "/>

Create a table

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M02/95/CA/wKiom1kZqtKgu8KSAADrqF46V4k190.png "style=" float : none; "title=" 21.png "alt=" Wkiom1kzqtkgu8ksaadrqf46v4k190.png "/>

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

650) this.width=650; "src=" https://s1.51cto.com/wyfs02/M00/95/CA/wKiom1kZqtWjv6k8AAbueIWg4lI078.jpg "style=" float : none; "title=" 22.jpg "alt=" Wkiom1kzqtwjv6k8aabueiwg4li078.jpg "/>

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M00/95/CA/wKioL1kZqtXgR9IWAABbAEL5Elk965.png "style=" float : none; "title=" 23.png "alt=" Wkiol1kzqtxgr9iwaabbael5elk965.png "/>

Select New query to create a database using the command line

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M01/95/CA/wKiom1kZqtWxWGChAACgXO7fkqk156.png "style=" float : none; "title=" 24.png "alt=" Wkiom1kzqtwxwgchaacgxo7fkqk156.png "/>

Create a database ACCP

650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M00/95/CA/wKiom1kZqtnhogqlAAgTrLb5dmo691.jpg "style=" float : none; "title=" 25.jpg "alt=" Wkiom1kzqtnhogqlaagtrlb5dmo691.jpg "/>

650) this.width=650; "src=" https://s4.51cto.com/wyfs02/M01/95/CA/wKioL1kZqtmyLk28AAEkfPOxN_I141.jpg "style=" float : none; "title=" 26.jpg "alt=" Wkiol1kzqtmylk28aaekfpoxn_i141.jpg "/>

Create a table in the form of a command

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M00/95/CA/wKioL1kZqtnSljfdAAApmz2IiKA601.png "style=" float : none; "title=" 27.png "alt=" Wkiol1kzqtnsljfdaaapmz2iika601.png "/>

Querying the contents of an entire table

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M02/95/CA/wKiom1kZqtmi6oNHAAAcAX_uZxU680.png "style=" float : none; "title=" 28.png "alt=" Wkiom1kzqtmi6onhaaacax_uzxu680.png "/>

Inserting data into a table

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M01/95/CA/wKiom1kZqtqDuJeqAABUNeEtdE8681.png "style=" float : none; "title=" 29.png "alt=" Wkiom1kzqtqdujeqaabuneetde8681.png "/>

Whether the query was inserted successfully

650) this.width=650; "src=" https://s2.51cto.com/wyfs02/M01/95/CA/wKioL1kZqt3joocDAAeRuMqaMME133.jpg "style=" float : none; "title=" 30.jpg "alt=" Wkiol1kzqt3joocdaaerumqamme133.jpg "/>

Set a primary key for a professional number

650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M02/95/CA/wKiom1kZqt6RI0ENAAItmJa95r8127.jpg "style=" float : none; "title=" 31.jpg "alt=" Wkiom1kzqt6ri0enaaitmja95r8127.jpg "/>

Set constraint for age, between 0-100

650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M02/95/CA/wKioL1kZquHQSpMfAAivmO1uRnA014.jpg "style=" float : none; "title=" 32.jpg "alt=" Wkiol1kzquhqspmfaaivmo1urna014.jpg "/>

Set constraints for gender, type only male or female

650) this.width=650; "src=" https://s2.51cto.com/wyfs02/M01/95/CA/wKioL1kZrE3QL3EFAAbtoBVunlE474.jpg "style=" float : none; "title=" 33.jpg "alt=" Wkiol1kzre3ql3efaabtobvunle474.jpg "/>

Associating two tables, setting foreign keys

650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M00/95/CA/wKioL1kZrFHwIsA3AAg5NJUH0GQ983.jpg "style=" float : none; "title=" 34.jpg "alt=" Wkiol1kzrfhwisa3aag5njuh0gq983.jpg "/>

See if the foreign key is set successfully, the primary key is yellow, the foreign key is gray

650) this.width=650; "src=" https://s2.51cto.com/wyfs02/M01/95/CA/wKiom1kZrFKQbIpVAAPPOJ44E5Y942.jpg "style=" float : none; "title=" 35.jpg "alt=" Wkiom1kzrfkqbipvaappoj44e5y942.jpg "/>

Then verify that the inserted data violates which rules, this is a violation of the age range, can only be 0-100

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M02/95/CA/wKiom1kZrFOxnQXqAABHH8GJzY8194.png "style=" float : none; "title=" 36.png "alt=" Wkiom1kzrfoxnqxqaabhh8gjzy8194.png "/>

This is a violation of this, there can be no duplication of content

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M02/95/CA/wKioL1kZrFPRceXPAABIf0Er6tE595.png "style=" float : none; "title=" 37.png "alt=" Wkiol1kzrfprcexpaabif0er6te595.png "/>

This is a violation of the gender constraints, can only enter male or female

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M01/95/CA/wKioL1kZrFOipNnvAABSjOngIz4461.png "style=" float : none; "title=" 38.png "alt=" Wkiol1kzrfoipnnvaabsjongiz4461.png "/>

This is a violation of the referential restrictions and cannot refer to non-existent ganso

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M00/95/CA/wKiom1kZrFTjt6YuAACGukHW0eg691.png "style=" float : none; "title=" 39.png "alt=" Wkiom1kzrftjt6yuaacgukhw0eg691.png "/>

Multi-Table Query

650) this.width=650; "src=" https://s2.51cto.com/wyfs02/M00/95/CA/wKioL1kZrFaj2p85AAUYeDXuumg022.jpg "style=" float : none; "title=" 40.jpg "alt=" Wkiol1kzrfaj2p85aauyedxuumg022.jpg "/>

This article is from "Love Linux" blog, reproduced please contact the author!

SQL Server database installation and basic management on server 2008r2