Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks
To Generate :
DECLARE @Names VARCHAR(8000) ;DECLARE @i int=0; SELECT top 10 @Names = COALESCE(@Names +', ', '') + '[' + COLUMN_NAME+ ']' FROM dbo.site_DatabaseFields where TABLE_CATALOG + '.' + TABLE_SCHEMA + '.' + TABLE_NAME = 'JDB.dbo.Invoices' SELECT @Names
[AccNo], [Attach], [BankName], [Branch], [BranchSer], [CName], [City], [CriditPeriod], [CusPO], [DiffDay]
[AccNo] as Field1, [Attach] as Field2, [BankName] as Field3, [Branch] as Field4, [BranchSer] as Field5, [CName] as Field6, [City] as Field7, [CriditPeriod] as Field8, [CusPO] as Field9, [DiffDay] as Field10
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.