How do I exclude auto generated columns from SQL Server Generate Script Data Only?
SQL Server Generate Script does a great job of creating a script for the data in the tables using the Data Only option for 'Types of data to script' in the advanced option. However the script generated also includes all the identifiers such as rowid() and integer ids. Understandably this is for referential integrity, but is there a way to exclude such columns?
Solution
Not in SSMS itself.
You can use a 3rd party tool such as the free SSMS Tools pack which has a "generate script from grid results" option. So you can generate INSERTs for SELECT col1, col3, col6 FROM MyTable (skipping some columns).
May be useful...
- Why does my query fail to convert a varchar value to int?
- Verify and/or Recommend Re Database Design for an Internal Admin Chat System
- Tricky SQL update
- How to select the last record of a table in SQL?
- Search multiple occurrences of a word in a string
- Login failed for user 'NT AUTHORITY\NETWORK SERVICE'
- How do I perform a simple string mapping as part of a t-sql select?
- Joining Two CTE's with Pivots
- SQL Server query to find all permissions/access for all users in a database
- SQL - Continue running all SQL statements even after error
- Best alternative for the Top Clause in Sql Server 2008?
- How to remove a specific character from a string, only when it is the first or last character in the string.
- Cannot open backup device. Operating System error 5
- How to grant database user read/write access roles the "new way"?
- Procedure is not returning any data when run from VB6
- TSQL rollup -return not null
- SQL Stored Procedures not finishing when called from Python
- How to remove or alter the dbo prefix from SQL Server 2012 tables?
- Date format in dd/MM/yyyy hh:mm:ss
- "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" Error in importing process of xlsx to a sql server
- How to split a comma-separated value to columns
- Where value in column containing comma delimited values
- How do I find a disabled index on SQL server 2008
- Attach multiple databases using T-SQL
- "č" converted to "c" when querying through SQL Server 2008
- How to find circular dependent table in sql server
- Running Sql Server stored proc in context of caller
- SQL Server misses that column doesn't exist
- Convert varchar list to int in Sql Server
- How do I store the select column in a variable?