SELECT FirstNm, LastNm, email
FROM dbo.Users
{
"first_name": "Aleks",
"last_name": "Demo",
"email_addresses": [
{
"email_address": "support@domain.com"
}
]
}
SELECT
'{
"first_name": "' + FirstNm + '",
"last_name": "' + LastNm + '",
"email_addresses": [
{
"email_address": "' + email + '"
}
]
}' as json_result
FROM dbo.Users
get result from sql as
Open in new window
then use asp
Open in new window
or try
Open in new window