Warm tip: This article is reproduced from serverfault.com, please click
Generate script without primary key
发布于 2013-05-14 18:32:58
I'm trying to make a generated script of my data (I mean, all the INSERT INTO commands). Because access permissions, I can't do a SET IDENTITY_INSERT TABLE OFF and ON (I'm using the user application in Staging)
So, there is a way to make this script in SQL Server Manager and avoid the field with the primary key? I set to false all properties (primary, unique, etc), but the script is still sending this field (For e.g., RecID 1, 2, 3, etc).
I'm using SQL Server 2012.
My configuration for the script:
Results I get:
SET IDENTITY_INSERT -TABLE- ON
INSERT INTO TABLE (ID,Field1) VALUES (1,'value')
Any solution (except for removing it with Notepad++) is appreciated.
Questioner
Leandro
Viewed
0
OMG, it was so easy that I never thought about it! I was thinking in make some SP with fetch cursor and etc. LOL. Thanks a lot.
It comes in handy in many situations when you need to transform data and don't have regex handy... it has saved me several times over the years!
and what about nulls? I've some records with null (smalldatetime field)