Sql

Search

xml to column sql

SELECT TheKey, 
    TheData.value('(/Group1/Title/Name)[1]', 'varchar(100)') AS Name,
    TheData.value('(/Group1/Title/Phone)[1]', 'varchar(100)') AS Phone,
    TheData.value('(/Group1/Title/Email)[1]', 'varchar(250)') AS Email,
    TheData.value('(/Group1/Title/State)[1]', 'varchar(100)') AS [State]
FROM MyTable

Comment

PREVIOUS	NEXT

Code Example
Sql :: oracle create index if not exists
Sql :: creating tables in sql with python
Sql :: cascade syntax in sql
Sql :: mssql unique key accept nulls
Sql :: Failed to process SQL command - ORA-28014: cannot drop administrative user or role
Sql :: plsql find location of procedure
Sql :: To log postgres db in without a password
Sql :: SQL/delete
Sql :: sql select where id not exists in another table
Sql :: codeigniter dbforge add index
Sql :: sql length
Sql :: sql select inside select sub query
Sql :: merge command in sql
Sql :: mysql copy row with new id
Sql :: default column value in sql same as another column laravel
Sql :: Triggers Syntax
Sql :: change date in pivot table to month in sql server
Sql :: connectionString
Sql :: sql server get number of working days in a month
Sql :: order by postgres
Sql :: HAS VALUE CHECK IN SQL
Sql :: sql injection
Sql :: trigger sql server
Sql :: right join
Sql :: one to many sql
Sql :: stuff and replace in sql
Sql :: oracle alter table
Sql :: sequelize postgresql schema
Sql :: query params sql insert python f string
Sql :: make a socket server to detect changes in mysql

Search

SQL

xml to column sql

ADD CONTENT