Insert the data from another table, then follow the below way..:rose::thumbsdown:
INSERT INTO InsCarriers_Copy
( InsCarrierId,
InsCarrierName,
ShortDescription,
ContactPhoneNo,
Location,
PhoneExt,
Fax,
Address1,
Address2,
ZipCode,
City,
State,
IsActive
)
SELECT InsCarrierId,
InsCarrierName,
ShortDescription,
ContactPhoneNo,
Location,
PhoneExt,
Fax,
Address1,
Address2,
ZipCode,
City,
[State],
IsActive
FROM InsCarriers