Skip to main content

Posts

Indexes

Practical Learning: Introducing Indexes Start Microsoft SQL  Server  and login to open the Microsoft SQL Server Management Studio To create a new database, in the Object Explorer, right-click Databases and click New  Database ... Set the name to  CollinsUniversity  and click OK In the Object Explorer, expand CollinsUniversity Right->click Tables and click New Table... Click the fields as follows:   Column Name Data Type Allow Nulls StudentNumber int Unchecked FirstName nvarchar(20) Checked MI nchar(1) Checked LastName nvarchar(20) Unchecked Username nvarchar(20) Unchecked Password nvarchar(20) C hecked Close the table When asked whether you want to save it, click Yes Set the name to  StudentRegistration Click OK On the Standard toolbar, click the New Query button  To create a new database and a table, type the following:   IF EXISTS(SELECT name FROM sys.databases WHERE name = N'CeilInn3') DROP DATABASE CeilInn3; GO CREATE DATABASE CeilI...