dimanche 29 mars 2015

How to concatenat or bind any hard code value with database returned value?

I am writing a select query like that "select Data from table1 where 1d=1" that will return me output like that



id Data
1 10


now i want output like that



id Temp Data
1 2 10


the query "select '2',Data from table1 where 1d=1" give me the required output.But when database return null It should be like that



id Temp Data
1 2 null


But it will return 0 row.Kindly tell me the query to get the required output . Thanks in advance.


Aucun commentaire:

Enregistrer un commentaire