sqlsql-servert-sqlsql-server-2000data-export
How do I export a table's data into INSERT statements?
How can I export a table from a SQL Server 2000 database to a .sql file as a bunch of INSERT INTO statements?
One of the fields in the table is a Text datatype and holds HTML so doing this by hand would be rather time-consuming.
I have access to SQL Server Management Studio 2008 to access the SQL Server 2000 database.
Solution
Check out the SSMS Tool Pack - it's a great, FREE add-on for SQL Server Management Studio which does a lot of things - among other it can generate INSERT statements from a given table.
- Setting the ft_min_word_len to 2 via console
- Analyzing Color Breakdowns by Name
- How to fetch records having difference of 5 minutes or less | Oracle
- How important is the order of columns in indexes?
- How do composite indexes work?
- Get a list of dates between two dates
- Why do multiple-table joins produce duplicate rows?
- SQL: Nested select query?
- MySQL slow query when combining two very fast queries
- How to retrieve Common Table Expressions (CTEs) as a R list?
- How to SQL Filter for Timestamp Differences in Toad for Oracle?
- SQL - How to get Distinct Values from a Column that are Unique to an Entry in another Column?
- SQL – How to find all entries that are missing certain expected criteria?
- Adding column to select statement in SQL causes timeout
- What is the most suitable data type for a column in a table?
- FULL OUTER JOIN on TWO MYSQL TABLES WITH 3 RELATING COLUMNS
- SQL Pivot on Conditional Count
- SQL Server indexes - ascending or descending, what difference does it make?
- Conditional Count on a column
- SQL query LEFT JOIN two tables with WHERE clause for the second table's column
- Query to concatenate row data in each group
- Combine 2 SQL Statements
- DB2 Conditional WHERE clause
- How do you escape underscores and single quotes in Amazon Athena queries?
- Insert a SET element into mysql db table with PHP
- How to find percentage on in SQL?
- How to get the last second word from String
- How it works a mysql query with alias?
- Microsoft Access SQL
- why this SQL statement doesn't work for finding the differences between two tables based on some key fields