Category: MsSql
-
MsSql – For Json auto
For Json variations Index Syntax Description Example (Simplified) Results (Simplified) 1 FOR JSON PATH Formats the result as JSON with nesting SELECT name, surname FROM users FOR JSON PATH [{ “name”: “John”, “surname”: “Doe” }] 2 FOR JSON PATH, ROOT(‘name’) Adds a root element to JSON output SELECT name FROM users FOR JSON PATH, ROOT(‘users’)…
-
How to create a linked server
Article that actually works: How to create a linked server mssql