SELECT [name] AS ColNames FROM syscolumns WHERE id=OBJECT_ID('Employees') AND [colid] < 4 ORDER BY [colid]
SELECT '(' + STRING_AGG([EmployeeID], ',') + '),' + '(' + STRING_AGG([LastName], ',') + '),' + '(' + STRING_AGG([FirstName], ',') + ')' AS [StringCol] FROM [Northwind].[dbo].[Employees]
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.