[Solved] Identity Increment [closed]

Question

First, you should know that you are doing a cartesian product of your tables. If you want to add an identity column when you are creating your table, then do the following:

Select IDENTITY(INT,1,1) ID, Calls.*,Patient.*
INTO Calls2
From Calls,Patient

Accepted Answer

First, you should know that you are doing a cartesian product of your tables. If you want to add an identity column when you are creating your table, then do the following:

Select IDENTITY(INT,1,1) ID, Calls.*,Patient.*
INTO Calls2
From Calls,Patient