SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Script Tbl Data to Insert Stmts. - Handles Unicode

By StormNorm, 2006/01/24

Total article views: 392 | Views in the last 30 days: 14

Script Table Data to Insert Statements - Handles Unicode datatypes (nchar, nvarchar, ntext). This script works with SQL 2000 and has been improved to handle properly the nchar, nvarchar, and ntext data types for Unicode, as well as handle apostrophes in data correctly. Usage is to run the script to create the stored proc in the database that contains the table you want to script inserts for, then call the proc in the context of that database as follows: exec InsertGenerator @tableName = 'myTableName' ... Original script from, and thanks go to Sumit Amar at,
http://www.codeproject.com/database/InsertGeneratorPack.asp.

By StormNorm, 2006/01/24

Total article views: 392 | Views in the last 30 days: 14
Your response
 
 
Related Articles
FORUM
FORUM

Scripting Remote Database using SMO in .net

Can't script remote database using script method

FORUM

movingview scripts from one database to another

movingview scripts from one database to another

FORUM

script for Checking database online or not

script for Checking database online or not

Tags
miscellaneous    
t-sql aids    
 
Contribute

Free registration required...

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Login (existing users)

Login

Email:   Password:   Remember me: Forgotten your password?

Register (new users)

Register

Email:   Password:
Confirm:

Subscribing to our newsletters gets you:

  • ALL of our content (thousands of articles, scripts, and forum postings)
  • A daily newsletter (example)
  • A weekly news round up (example)
  • The opportunity to ask and answer questions in our forums
  • A daily Question of the Day to test and help you increase your knowledge of SQL Server.

Steve Jones
Editor, SQLServerCentral.com