SQL-Server-2008数据库—创建、建表、查询语句

地形平坦开阔，地层由第四系全新冲积层，第四系上更新统冲层组成，局部表覆第四系全新统人工堆积层。第四系全新统冲积层厚度约25～50m，岩性主要为黏土、粉质黏土、粉土、粉砂、细砂；第四系上更新统冲积层厚度大于50m，岩性主要为黏性土、粉土、粉细砂等。管桩深度范围内地层主要为：粉土、黏土、粉质黏土，局部表层为杂填土。couplingCentreshallbechecked,thesecondpouredconcretestrengthofmorethan70%.Intheprocessofreamingorboring,apartfromthespecialprovisionsinfactory,doesnotallowanyworkthatmayaffectthecouplingCentre,suchasirrigation,tocylinderconnectionstofloodthecondenserpipesandsoon.Wellboring,hingeboltholeflangewithcouplingofvertical,notoblique.Mountingboltsshouldbeaddedlubricants,typinggentlywithasmallhammer,nottoolooseortootight,packedtheboltswiththecorrespondingsealscrewholeshouldbemarked.6.4.5.4.2couplingreamedandpairingsisclosetothediameterofboltbearinggoodhingeholes,dressedwithagoodtwocouplingboltsbeforeyoucanmovetherotor,boring-reamingholeinturn.Couplingboltsmustbetightcouplingissymmetricaldiameter,inboring,reaming,twoboltsout.Wellboring,hingeboltholeflangewithcouplingofvertical,notoblique.Duetothecouplingboltsinaccordancewithhingeholescorrespondingtothediameterofthescrewholesonebyoneafterprocessing,processingbackboltinstallationlocationcannotbechanged,soaccordingtoboltaftertheactualweightdifferenceofnutandlockwashertomatch.Generalrequirementsforcouplingtwosymmetricaldiameterbolt,nutandlockwasher'stotalweightdifferenceshouldnotbegreaterthan10gandknocksstampedmark.(SeeFigure18)Thecouplingboltsapplylubricant,andthengentlywithcopperhome,nottoolooseortootight.BoltAssemblyisfinished,symmetricaltighteningallboltsto30%,50%,70%,100%force,andcheckthecouplingflutterandbeforeconnectingthecirclegraduallychangesitsvalueshouldbelessthan0.02mm.Tighteningtorqueofthecouplingboltsshallcomplywiththetechnicalrequirementsmanufacturersdrawings,withadynamometricwrenchorlogtensiontools.Threewheelrotorswingtestcouplingconnectionsshouldbechecked:takingleave,SQLServer2008数据库—创建、建表、查询语句一、创建数据库1、利用对象资源管理器创建用户数据库：（1）选择“开始”—“程序”—MicrosoftSQLServer2008—SQLServerManagementStudio命令，打开SQLServerManagementStudio。（2）使用“Windows身份验证”连接到SQLServer2008数据库实例。（3）展开SQLServer实例，右击“数据库”，然后人弹出的快捷菜单中选择“新建数据库存”命令，打开“新建数据库”对话框。（4）在“新建数据库”对话框中，可以定义数据库的名称、数据库的所有者、是否使用全文索引、数据文件和日志文件的逻辑名称和路径、文件组、初始大小和增长方式等。输入数据库名称student。2、利用T-SQL语句创建用户数据库：在SQLServerManagementStudio中，单击标准工具栏的“新建查询”按钮，启动SQL编辑器窗口，在光标处输入T-SQL语句，单击“执行”按钮。SQL编辑器就地形平坦开阔，地层由第四系全新冲积层，第四系上更新统冲层组成，局部表覆第四系全新统人工堆积层。第四系全新统冲积层厚度约25～50m，岩性主要为黏土、粉质黏土、粉土、粉砂、细砂；第四系上更新统冲积层厚度大于50m，岩性主要为黏性土、粉土、粉细砂等。管桩深度范围内地层主要为：粉土、黏土、粉质黏土，局部表层为杂填土。couplingCentreshallbechecked,thesecondpouredconcretestrengthofmorethan70%.Intheprocessofreamingorboring,apartfromthespecialprovisionsinfactory,doesnotallowanyworkthatmayaffectthecouplingCentre,suchasirrigation,tocylinderconnectionstofloodthecondenserpipesandsoon.Wellboring,hingeboltholeflangewithcouplingofvertical,notoblique.Mountingboltsshouldbeaddedlubricants,typinggentlywithasmallhammer,nottoolooseortootight,packedtheboltswiththecorrespondingsealscrewholeshouldbemarked.6.4.5.4.2couplingreamedandpairingsisclosetothediameterofboltbearinggoodhingeholes,dressedwithagoodtwocouplingboltsbeforeyoucanmovetherotor,boring-reamingholeinturn.Couplingboltsmustbetightcouplingissymmetricaldiameter,inboring,reaming,twoboltsout.Wellboring,hingeboltholeflangewithcouplingofvertical,notoblique.Duetothecouplingboltsinaccordancewithhingeholescorrespondingtothediameterofthescrewholesonebyoneafterprocessing,processingbackboltinstallationlocationcannotbechanged,soaccordingtoboltaftertheactualweightdifferenceofnutandlockwashertomatch.Generalrequirementsforcouplingtwosymmetricaldiameterbolt,nutandlockwasher'stotalweightdifferenceshouldnotbegreaterthan10gandknocksstampedmark.(SeeFigure18)Thecouplingboltsapplylubricant,andthengentlywithcopperhome,nottoolooseortootight.BoltAssemblyisfinished,symmetricaltighteningallboltsto30%,50%,70%,100%force,andcheckthecouplingflutterandbeforeconnectingthecirclegraduallychangesitsvalueshouldbelessthan0.02mm.Tighteningtorqueofthecouplingboltsshallcomplywiththetechnicalrequirementsmanufacturersdrawings,withadynamometricwrenchorlogtensiontools.Threewheelrotorswingtestcouplingconnectionsshouldbechecked:takingleave,提交用户输入的T-SQL语句，然后发送到服务器执行，并返回执行结果。创建数据库student的T-SQL语句如下：CreatedatabasestudentOnprimary(name=student_data,filename='E:\SQLServer2008SQLFULL_CHS\MicrosoftSQLServer\MSSQL10.MSSQLSERVER\MSSQL\DATA\student_data.mdf',size=3,maxsize=unlimited,filegrowth=1)Logon(name=student_log,filename='E:\SQLServer2008SQLFULL_CHS\MicrosoftSQLServer\MSSQL10.MSSQLSERVER\MSSQL\DATA\student_log.ldf',size=1,地形平坦开阔，地层由第四系全新冲积层，第四系上更新统冲层组成，局部表覆第四系全新统人工堆积层。第四系全新统冲积层厚度约25～50m，岩性主要为黏土、粉质黏土、粉土、粉砂、细砂；第四系上更新统冲积层厚度大于50m，岩性主要为黏性土、粉土、粉细砂等。管桩深度范围内地层主要为：粉土、黏土、粉质黏土，局部表层为杂填土。couplingCentreshallbechecked,thesecondpouredconcretestrengthofmorethan70%.Intheprocessofreamingorboring,apartfromthespecialprovisionsinfactory,doesnotallowanyworkthatmayaffectthecouplingCentre,suchasirrigation,tocylinderconnectionstofloodthecondenserpipesandsoon.Wellboring,hingeboltholeflangewithcouplingofvertical,notoblique.Mountingboltsshouldbeaddedlubricants,typinggentlywithasmallhammer,nottoolooseort