when i run this insert statement:
INSERT INTO TblStudent
SELECT UsernameID AS UsernameID
WHERE (UsernameID = UsernameID)
i get this error: [Microsoft][ODBC SQL server Driver][SQL Server] Cannot insert explicit value for identity column in table 'TableName' when IDENTITY_INSERT is set to OFF
I have installed service pack 3.
Do i need to do anything else? Or is there something wrong with my insert statement?