sql query database code example

Example 1: css in sql query

SELECT  'test1' AS [@class]
    , ( SELECT  'test2' as [@class]
        , (SELECT 'Name' FOR XML PATH(''))
        FOR XML PATH('td'), type)
    ,(SELECT  'test3' as [@class]
        , (SELECT 'Value' FOR XML PATH(''))
        FOR XML PATH('td'), type) 
FOR XML PATH('tr'), type

Example 2: sql select

Everything in brackets is optional.
SELECT [all/distinct] <COL1>, <COL2>, <COL3>
FROM <TABLE_NAME>
[JOIN <JOIN_CONDITION>]
[WHERE <CONDITION>]
[GROUP BY <COLUMN_NAME>]
[HAVING <SEARCH_CONDITION>]
[ORDER BY <SORT_SPECIFICATION>]

Tags:

Sql Example

Related