Hi all,
I tried to learn Indexes Fundamentals from
http://www.functionx.com/sqlserver/Lesson30.htm. From that website (Page 1 of 16), I saw the following code:
Practical Learning: Introducing Indexes
Launch Microsoft SQL Server and connect
On the Standard toolbar, click the New Query button
To create a new database and a table, type the following:
CREATE DATABASE InformationTechnologyJournal1;
GO
USE InformationTechnologyJournal1;
GO
CREATE SCHEMA Publishing;
GO
CREATE SCHEMA Authorship;
GO
CREATE TABLE Authorship.Reviewers
(
ReviewerNumber nchar(6) not null,
FirstName nvarchar(24),
MiddleName nvarchar(24),
LastName nvarchar(24),
Citizenship nvarchar(40)
);
GO
To execute, press F5
I guess this set of Code Statements is supposed to be executed in the regular version of SQL Server, not in the SQL Server Management Stu ...
Go to the complete details ...