is this possible ??

[geffry]

I need to print a message from isql.

print 'Text is ' + @name

I need to print my string and the value of the variable @name in the same line.

print 'Text is'
print @name

If i do like this a new line appears, Can i combine the above two prints to get the ouput in a single line.

thanks

 

[saikrish]

Hi geff,

It is quite possible. Try this.

isql -U xyz -P abc -S lkj -D mno << EOF
declare @name char(20)
select @name = 'geffry'
exec(&quot;print 'Text is &quot; + @name + &quot;'&quot
go
EOF

Note the space included in the string &quot;print 'Text is &quot; at the end. This is to avoid from the @name getting concatenated with 'Text is' without any space.


Vijay

 

[dickiebird]

I couldn't get ViJay's code to work.
I could get this to run OK though:-
isql -U ucontrol -P pcontrol << EOF
declare @name char(20)
declare @printline char(120)
select @name = 'geffry'
select @printline = 'Text is ' + @name
print @printline
go
EOF

HTH ((;-))) Dickie Bird
Honi soit qui mal y pense

 

[saikrish]

I don't understand what problem dickie had in executing the code supplied earlier. The basic idea was to avoid declaration of more variables.

Vijay

 

[cballada]

Estimado amigo, espero haberte entendido la idea, si no esto disculpas.

declare @name char(20)
select @name=&quot;Carlos &quot;

print &quot;text is, %1!&quot;, @name


Atte.
cballada

 

[geffry]

thanks sai and cballada