Haidong Ji

I was a developer, working with VB, SQL Server, Access and lots of other Microsoft stuff.

I am currently a SQL Server DBA in my company in the Chicago area.

I am MCSD and MCDBA certified. In my spare time, if I have any, I like to do Linux, C and other open source project.

I can be reached at Happy_Haidong@yahoo.com

SQLServerCentral Article

Code Generation: Using SQL to Generate SQL and Other Code

SQL Server is a great platform against which to develop, but it can also be used as a code generation tool with a little creativity. Haidong Ji brings us a few techniques that can be used to automatically build T-SQL code and bcp code for importing and exporting data.

You rated this post out of 5. Change rating

2005-02-14

17,938 reads

Blogs

Using OneLake for Excel Files in Microsoft Fabric

By

Hey data friends! This blog is to discuss an edge case I’ve run into...

Another AI Faux Pax

By

I was experimenting with a local model (article) and as a part of this,...

Monday Monitor Tips: Using the PowerShell API

By

Redgate Monitor has grown tremendously from its early days and I find many customers...

Read the latest Blogs

Forums

Transpose sql table rows into columns

By SQL Bee

I want to transpose sql table rows to columns. I have written a query...

Generate number fields

By dbayliss1978

Hi all, I hope someone can help with advice. What would be the best...

Sparse Column Defaults

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Sparse Column Defaults

Visit the forum

Question of the Day

Sparse Column Defaults

What are the restrictions for defaults on columns declared as sparse?

See possible answers