| Author |
 Topic  |
|
|
cplusplus
Constraint Violating Yak Guru
483 Posts |
 Posted - 11/06/2012 : 10:09:21
|
I want to use following query, how to get result within dbl quotes all fields, int fields, date field, text fields etc. if null just want to show "".
select actionID, actiondesc, duedate, asignedTo, comments from Tab_description table
result to appear as follows:
"23","myactiondesc","10/26/2012","Mario",""
thanks a lot for the helpful info.
|
|
|
webfred
Flowing Fount of Yak Knowledge
Germany
8529 Posts |
Posted - 11/06/2012 : 10:13:08
|
select
'"'+convert(varchar(20),actionID)+'"',
'"'+actiondesc+'"',
'"'+convert(varchar(10),duedate,103)+'"',
'"'+asignedTo+'"',
'"'+comments+'"'
from Tab_description table
Too old to Rock'n'Roll too young to die. |
 |
|
| |
Topic |
|
|
|
select query embed resul with double quotes
