SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE [dbo].[Authors]( [AuthorID] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](255) NOT NULL, CONSTRAINT [PK_Authors] PRIMARY KEY CLUSTERED ( [AuthorID] ASC ) ) ON [PRIMARY] insert into Authors (Name) Values ('Italo Calvino'); insert into Authors (Name) Values ('Umberto Eco'); select * from Authors; select count(*) from Authors; select Name from Authors; select AuthorID, Name from Authors; select AuthorID, Name from Authors where Name = 'Italo Calvino'; select AuthorID, Name from Authors where Name = 'Umberto Eco'; select AuthorID, Name from Authors where Name like '%Ca%';