Darren Gordon

Generate insert statements with column names for any or all tables

Generate a script of insert statements with column names for any table including those with identity columns.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.67 (3)

You rated this post out of 5. Change rating

2012-06-15 (first published: 2012-05-22)

3,117 reads

I’ll walk through the KDA UI and tackle the first challenge before diving into...

While I mostly write about SQL Server, I have a soft spot for Kusto....

Many organizations list customer testimonials and quotes on their websites or literature. It makes...

Comments posted to this topic are about the item Life Moves Pretty Fast

Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL...

Comments posted to this topic are about the item 50 Years of Microsoft

Can I have a collation expression like this in SQL Server 2022?

...
WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS
...