How to get all values separated by commas, with only a SELECT query and a variable.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(12)

You rated this post out of 5. Change rating

2012-07-19 (first published: 2012-07-03)

2,260 reads

Blogs

While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...

(This is the second post in a three-part series on how AI is changing...

I had seen these roles in various instances, but never dug into the new...

Forums

Comments posted to this topic are about the item Pay for Performance, which is...

Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...

Comments posted to this topic are about the item The ##MS_DatabaseConnector## User

On SQL Server 2025, I run this code as a sysadmin:

CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567'
GO
ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo
GO

I then login as Demo and run this:

USE sandbox
go
SELECT CURRENT_USER

What is returned?