Sql

Search

Parsing XML IN SQL Server

DECLARE @XMLData XML = '
<oo_outbound_order>   
    <oo_master>
        <Code>123</Code>
        <Name>Branan</Name> 
    </oo_master> 
</oo_outbound_order>'

SELECT
    [Code] = Node.Data.value('Code', 'INT'),
    [Name] = Node.Data.value('Name', 'NVARCHAR(20)')
    FROM @XMLData.nodes('/oo_outbound_order/oo_master') Node(Data)

Comment

PREVIOUS	NEXT

Code Example
Sql :: mssql dockere
Sql :: PSQL use LIKE with timestamps
Sql :: mysql grant all on all databases
Sql :: stored procedure to delete data from table in mysql
Sql :: average sql
Sql :: postgresql stored procedure update table values
Sql :: how to get 30 days previous date in mysql
Sql :: postgre alter table foreign key
Sql :: mysql remove first and last character from string
Sql :: drop a view in sqlite
Sql :: oracle free up space in tablespace
Sql :: alter table myisam to innodb
Sql :: sql round 2 decimal
Sql :: create date sql
Sql :: orcale index size
Sql :: how to change db owner postgres
Sql :: enable full text search mysql
Sql :: python dictionary to sql update
Sql :: FIND AVERAGE SALARY EARNER IN SQL
Sql :: mysql if
Sql :: list table columns sql
Sql :: Query to remove duplicate rows from a table
Sql :: mysql case
Sql :: sql server delete table
Sql :: sql server select another database
Sql :: postgres default value
Sql :: where condition in mongodb
Sql :: count the table indatabase
Sql :: sql select from multiple tables without join
Sql :: sql server today minus n

Search

SQL

Parsing XML IN SQL Server

ADD CONTENT