Sql

Search

json with root element in sql server

SELECT BusinessEntityID As Id,  
       FirstName, LastName,  
       Title As 'Info.Title',  
       MiddleName As 'Info.MiddleName'  
   FROM Person  
   FOR JSON PATH, ROOT('info'),INCLUDE_NULL_VALUES

Comment

PREVIOUS	NEXT

Code Example
Sql :: sql injection payload list github
Sql :: alter table add check constraint oracle
Sql :: how to check table name in current database sql
Sql :: flask sqlalchemy update row
Sql :: where with multiple conditions in mongodb
Sql :: reset auto increment mysql
Sql :: mysql compare timestamp in minutes
Sql :: how to get the date diff of 2 dates in the same fieldin sql server
Sql :: postgres like case insensitive
Sql :: sql server create constraint
Sql :: oracle index size
Sql :: default number in sql
Sql :: restart serial number for postgres
Sql :: calculate percentage in sql
Sql :: update sqlite
Sql :: sqlserver add column
Sql :: update foreign key value in mysql
Sql :: mysql count characters in string
Sql :: sqlite insert or update
Sql :: install latest mysql 8 linux server
Sql :: create table like another table
Sql :: sql count how many times a value appears
Sql :: @firebase/database: FIREBASE WARNING: update at /users failed: permission_denied
Sql :: install mysql 5.7 ubuntu 20.04
Sql :: reset keys in sql
Sql :: oracle sql sort ascending
Sql :: sql String comparisons case sensitive
Sql :: json_value oracle
Sql :: how to get all dates in a month in oracle
Sql :: add foreign key to existing table

Search

SQL

json with root element in sql server

ADD CONTENT