A new topic, 'mssql: insterting data into identity column', has been made on a
board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=36.new#new
The text of the topic is shown below:
Hi,
In order to insert data into the identity column of mssql db, I have figured
out that I can add:
<modifySql dbms="mssql">
<prepend value="SET IDENTITY_INSERT parameter_sets ON;"/>
<append value="SET IDENTITY_INSERT parameter_sets OFF"/>
</modifySql>
into changeset, or add specific <sql></sql> statements before/after insert.
Is there a way to set IDENTITY_INSERT before every insert so I do not have to
edit hundreds of changesets?
Thanks,
Brendan
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The LiquiBase Community Forum Team.------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises
looking to deploy the next generation of Solaris that includes the latest
innovations from Sun and the OpenSource community. Download a copy and
enjoy capabilities such as Networking, Storage and Virtualization.
Go to: http://p.sf.net/sfu/opensolaris-get
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
