Database

pradeep kulkarni wrote:

create querry to drop a row from table

DELETE FROM MyTable
WHERE primaryKey = 123

DROP TALBLE NAME

DELETE FROM TableName WHERE id = 101

INSERT INTO [InsertDB].[dbo].[InsertTable]<br />
           ( [ColumnName1],[ColumnName2] )<br />
   SELECT  [ColumnName1],[ColumnName2]<br />
FROM [SourceDB].[dbo].[SourceTable]

Sincerely,
Elina

Life is great!!!
Enjoy every moment of it!

pra47 wrote:

how to create table in SQL, give one example

SELECT b.[ID] as 'Parent', a.[ID] as 'Role'<br />
FROM Roles a<br />
INNER JOIN Roles b<br />
ON a.ParentID = b.[ID]

May Thu san wrote:

The above query can only show the first two child of ID 1 (which are 2,3) and did not show the child of parent 2 and 3...etc.

How can I get all children?

SELECT 
    Sens_Name,
    T2_value AS Stat_Value,
    'T2_Value' AS Stat_Type
FROM
    SensTable

UNION

SELECT 
    Sens_Name,
    Q_value AS Stat_Value,
    'Q_Value' AS Stat_Type
FROM
    SensTable

UNION

SELECT 
    Sens_Name,
    CMI_Value AS Stat_Value,
    'CMI_Value' AS Stat_Type
FROM
    SensTable

ORDER BY 
    Sens_Name,
    Stat_Value