[Solved] Identity Increment [closed]

by

[ad_1]

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

[ad_2]

solved Identity Increment [closed]