SQL Server - INSERT and ignore on duplicate key
Inserting values and ignoring duplicate key errors (or, other errors) can be done like this: BEGIN TRY INSERT INTO foo_table (...) VALUES (...) ... END TRY BEGIN CATCH END CATCH ...
Tip: How to Convert char to int
Converting char to int can be accomplished by subtracting '0': char c = '4'; int n = c - '0'; // gives the int value 4 ...
SQLServer - insert IDENTITY
Before inserting IDENTITY values in SQLServer you have to turn on IDENTITY_INSERT as here: SET IDENTITY_INSERT [foo_table] ON INSERT INTO foo_table (...) VALUES (...) ... SET IDENTITY_INSERT [foo_table] OFF ...