I have the following query, i am using the column alias by this way,
select work_Code as "Work Code",work_nature as "Work Nature" from sb_cm_work_nature
But i am using the VB.net forms as my front end application and i don't want to do any thing on my front end forms regarding this kind of things, as i have to just process this query on my MS SQL SERVER and the output of the query must have to assigned to the DATAGRID control of the vb.net forms.
The table 'dual' in Oracle is a fake table you can use to select manual values from the DB. For instance to get the system date you would do the following:
I know there is an equlivant to Oracle's 'dual' table in MS SQL, but I do not know what it is called.
Though you may have problems if the 'work_code' column is stored as a numerical field, as the columns joined by a 'union all' must be of the same datatype. As you can see the values of 'Work' & 'Code' selected from dual are strings and unless 'work_code' from sb_cm_work_nature is also a string you will have to do something ugly like this:
it helps me up to 99 %.
But still i m unable to convince my self that :
"Why we can't use the newline character ( viz. \n,\t in C++, C , and vbcrlf in vb,vb.net ) while mentioning the column alias in a select query.
G'd evening All!
Manish, in my opinion SQL is not designed to work without a Front End, so, we can't expect sql to have all (same) functions that almost any other OOL have, insted we should take advantage from both ends.... i mean to use the right tool for the job
Just to add a comment to Kate's post. The equivalent for [b]sysdate[b] IF systadate is what the name imply, is in MS SQL GETDATE()
Regards
Estuardo
Here is some T-SQL code that should acheive your objective:
[code] -- declare variables DECLARE @vchColumnOutput varchar(200) DECLARE @vchWorkCode varchar(100) DECLARE @vchWorkNature varchar(100) -- select data from tblWhatever into @variables SELECT @vchWorkCode = work_code,
@vchWorkNature = work_nature FROM tblWhatever -- insert a carriage return between work_code and work_nature SET @vchColumnOutput = @vchWorkCode +char(13)+ @vchWorkNature -- display work code and work nature SELECT @vchColumnOutput
[code]
I have the following query, i am using the column alias by this way,
select work_Code as "Work Code",work_nature as "Work Nature" from sb_cm_work_nature
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Offline 
Unsolved 
