Add row to the SQL result?

Question

Add row to the SQL result?

obarahmeh

SSCommitted

Points: 1595
More actions
November 5, 2009 at 2:46 am

#96472

Dear All,
I need to add a row to the result of SQL statement.
The Sql Statement is:
select ID, name from myTable;
the result:
ID name
1 name1
2 name2
3 name3
the previous result comes from the table, but I need to add a row in the result which is not in the table.
Is it possible to display a row in the result which does not exist in the table?
Regards

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

krayknot SSCertifiable Points: 7998 More actions · Answer 1

obarahmeh (11/5/2009)
Dear All,
I need to add a row to the result of SQL statement.
The Sql Statement is:
select ID, name from myTable;
the result:
ID name
1 name1
2 name2
3 name3
the previous result comes from the table, but I need to add a row in the result which is not in the table.
Is it possible to display a row in the result which does not exist in the table?
Regards

take the result in temporary table and add a new row and list it

kshitij kumar
kshitij@krayknot.com
www.krayknot.com

Nabha SSCrazy Eights Points: 8534 More actions · Answer 2

you have an advantae with this that, if any duplicates are there, its removed.

Create table #t(ID int, Name varchar(10))

INSERT INTO #t VALUES (1, 'abc')

INSERT INTO #t VALUES (2, 'def')

INSERT INTO #t VALUES (3, 'ghi')

SELECT * from #t

UNION

SELECT 4, 'jkl'

---------------------------------------------------------------------------------

Rookee DBA SSCrazy Points: 2188 More actions · Answer 3

Also union can be used

Select UserName from table B

Union

Select somecolumn as UserName from table B