Technical Article

Comma Separated List Of Field Names

Returns a single row with a single column containing a comma-separated list of the field names for a specified table. I find this very useful when doing INSERT statements where I have to list out each field being inserted. I simply bind this proc to a hotkey and use the hotkey to get the comma-separated […]

You rated this post out of 5. Change rating

2002-06-12

1,233 reads

Blogs

Microsoft finally adds Tenant Switcher for Fabric / Power BI

By

Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...

Microsoft Releases Windows 11 ARM ISO – A Game Changer for ARM-Powered Devices

By

Yesterday, Microsoft released the highly anticipated Windows 11 ARM ISO image, marking a major...

Building Effective Data Governance Framework: Top Areas to Focus On

By

The post Building Effective Data Governance Framework: Top Areas to Focus On appeared first...

Read the latest Blogs

Forums

Fill in missing hours for each VisitID during the day

By NineIron

create table #T ( VisitID varchar(30), ER_Date date, HR int ) insert into #T(VisitID,...

Database copy for report work load

By ashrukpm

Hi Team, I am looking for a an help, Please see my problem below....

Linking 2 SQL Databases

By SimonLM

Hi All I am a complete novice so I apologise for any incorrect terminology....

Visit the forum

Question of the Day

The Hash Join I

What are the two inputs called to a hash join operation in SQL Server? (choose 2)

See possible answers