[ID] [int] IDENTITY(1,1) NOT NULL
بعدشم من تست کردم مشکلی نداشت !
CREATE TABLE [dbo].[LeitnerCategory0] ( [id] INT NOT NULL,
[word] NVARCHAR (MAX) NOT NULL,
[mean] NVARCHAR (MAX) NOT NULL,
[imageURL] NVARCHAR (MAX) NULL,
[homeLVL] INT DEFAULT ((1)) NOT NULL,
PRIMARY KEY CLUSTERED ([id] ASC)
);
GO
CREATE TABLE [dbo].[LeitnerCategory1] (
[id] INT NOT NULL,
[word] NVARCHAR (MAX) NOT NULL,
[mean] NVARCHAR (MAX) NOT NULL,
[imageURL] NVARCHAR (MAX) NULL,
[homeLVL] INT DEFAULT ((1)) NOT NULL,
PRIMARY KEY CLUSTERED ([id] ASC)
);
GO
INSERT INTO [dbo].[LeitnerCategory1]
SELECT
[id] ,
[word] ,
[mean] ,
[imageURL] ,
[homeLVL]
FROM [dbo].[LeitnerCategory0]
GO