CREATE TABLE [dbo].[Archivio_mov_new](
  [IdDb] [bigint] IDENTITY(1,1) NOT NULL,
  [codalbergo] [int] NOT NULL,
  [codcomalbergo] [int] NOT NULL,
  [DataArrivo] [smalldatetime] NULL,
  [DataPartenza] [smalldatetime] NULL,
 CONSTRAINT [PK_Archivio_mov_new] PRIMARY KEY CLUSTERED 

poi inserisco questi dati:

Insert into archivio_mov_new (codalbergo,codcomalbergo,dataarrivo,datapartenza) Values('10','60038','2008-11-01','2008-11-03')