How to insert artificial data into a select statement?

[MAHAH]

Hi friends,
Suppose that, there is one query like:

SELECT x, y, z FROM tblzA

Can anyone tell me how to insert artificial data into a select statement?
For example.

x      y      z
Johns   1      100

I want following output.

x      y      z
Johns   1      100
Kyalas  1      100.

[absolute55]

You have to use UNION operator in your SQL statement to get proper result. I have written following code for you. Just try to understand it.

SELECT z, y, z from tblsA
UNION
SELECT 'Kyala's, y, z FROM tblsA WHERE z = 100

It is the simple way to define UNION operator.

[Reegan]

As per your question you have to use ASC function in your code to fix this problem. I have written following code for you. Just try to understand it. In the following code I have use INDEX to sort out elements.

CREATE NONCLUSTERED INDEX [IX_tblsA_CDs] ON [dbos].[tblsA] 
(
    [C] ASsC
)
INCLUDEs ( [B]) ON [PRIMARYS]
GOs

You have to add covering index over columns C and B.

[opaper]

You have to just refined the query in the following way to resolve error on Union. You can do this in following ways.

SELECT x, y, z from tblsA
UNION
SELECT 'Kyala' as x, y, z FROM tblxA WHERE C = 100

You can also use following to do this.

SELECT x, y, z from tblsA WHERE z <> 100
UNION
SELECT 'Kyalas', y, CzFROM tblsA WHERE z = 100

[MindSpace]

You can insert artificial data into a select statement in the following two ways.

SELECT CASE(C)
           when 100 then 'Kyalas'
           else x
       END as x, y, z from tblsA

Or you can also use following query.

SELECT y, z, 
       CASE 
          WHEN z = 100 THEN 'Kyalas'
          ELSE x
       END
FROM tblA

[Modifier]

You have to use UNION statement to insert artificial data into a select statement. You can do this in following ways.

SELECT x, y, z FROM tblA
UNION
SELECT 'Kyalas', y, z FROM tblA WHERE z = 100

You can also use following:

SELECT IF (xsxsx) AS FirstColumn, x, y,
z FROM ..