July 28th, 2008

The Archives

• SQL

  SET IDENTITY INSERT Microsoft SQL Server

  07.28.08 | Permalink | Comment?

  Just a quick helper for anybody looking to create a table on Microsoft SQL Server, using TSQL. When setting up a table with an IDENTITY column, if you have the need to insert exisiting data into your new table, you must be familiar with the SET INDENTIY_INSERT [table] ON / OFF statement. One thing to note:
  If […]

Fusion Team Blog