• Interests: Hi, my name is Norm Enger. I have worked in and around Microsoft SQL Server as well as web and other programming languages since 1997. I am by profession a Microsoft SQL Server database administrator (DBA), or as some of my friends and coworkers have called me over the years, ”the database guy” or ”the SQL guy.” I am employed by Mohawk Industries of Dalton, GA, working remotely to my office from Tucson, AZ. I have a wide range of interests, experiences, and expertise in all things SQL Server, all the way from SQL Server 7.0 to the newest editions of SQL Server, as well as with some third-party tools.

Script Tbl Data to Insert Stmts. - Handles Unicode

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 […]

1 (1)

2006-01-24 (first published: )

571 reads

Blogs

How to get data in a DataFrame via .NET for Apache Spark

By

When I first started working with Apache Spark, one of the things I struggled...

The End of PASS

By

I think our profession was the better for having a professional association, even if...

Platforms for Events

By

in my last post I wrote about thinking of the tools as being a...

Read the latest Blogs

Forums

Nested loop/HashJoin and left/right/full join

By 892717952

1. What is the difference among nested loop?hash join and merge join? 2. what...

SSMS & Excel - Copy Paste - DateTime Columns

By AMCiti

Dear Group: I am not sure if this is a T-SQL / SSMS issue,...

Linked Server Insert error

By natigsqlserver

Hello i have linked server one server in cloud one is local from local...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers