asked on 2012 SQL to JSON Select
I am using MS SQL 2012. Is there a way to get results in a JSON format from a recordset and use them to pass them as a string to post to an URL ?
For example a simple query
So it returns:
Is this posible from SQL or do I need to do this afterwards in ASP. I am using ASP Classic.
For example a simple query
SELECT FirstNm, LastNm, email
FROM dbo.Users
So it returns:
{
"first_name": "Aleks",
"last_name": "Demo",
"email_addresses": [
{
"email_address": "support@domain.com"
}
]
}
Is this posible from SQL or do I need to do this afterwards in ASP. I am using ASP Classic.
ASPSQLJSON
Last Comment
Aleks
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Both return errors
Second and third: Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'as'.
and the first one:
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near ': '.
Msg 105, Level 15, State 1, Line 7
Unclosed quotation mark after the character string '
}
]
}' as json_result
FROM dbo.Users
'.
I am using MS SQL 2012
Second and third: Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'as'.
and the first one:
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near ': '.
Msg 105, Level 15, State 1, Line 7
Unclosed quotation mark after the character string '
}
]
}' as json_result
FROM dbo.Users
'.
I am using MS SQL 2012
ASKER
I checked the first one and used:
It returns :
{ "first_name": "Jose", "last_name": "JONES", "email_addresses": [ { "email_address": "" } ] }
Which is valud JSON. Thank you!
SELECT
'{
"first_name": "' + FirstNm + '",
"last_name": "' + LastNm + '",
"email_addresses": [
{
"email_address": "' + email + '"
}
]
}' as json_result
FROM dbo.Users
It returns :
{ "first_name": "Jose", "last_name": "JONES", "email_addresses": [ { "email_address": "" } ] }
Which is valud JSON. Thank you!
ASKER
Not there is a syntax error. it is displayed at the bottom.
get result from sql as
Open in new window
then use asp
Open in new window
or try
Open in new window