{{theTime}}

Search This Blog

Total Pageviews

Generate Insert Sql from Select Statement

SELECT 'INSERT INTO ReferenceTable (ID, Name) VALUES (' +
       CAST(ID AS NVARCHAR) + ', ''' + Name + ''');'
FROM ReferenceTable
FOR XML PATH('');

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Setup AWS Application Load Balancer Https

Setting up HTTPS for an AWS Application Load Balancer (ALB) involves configuring an HTTPS listener, deploying an SSL certificate, and defini...