Re: OSQL Query

From: beginthreadex (thomas_remkus_at_westwoodone.com)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 10:53:00 -0500

'data' + char(5) + char(5) + 'otherData'

> Murray Jack wrote:

> Hi
>
> I am running a large batch update of a series of stored procedures on my
> SQL Server database using the command line OSQL.exe application
>
> The problem i have is:
>
> In one of the stored procs I concatanate a series of text strings with the
> character '¬' so that i can split the string when it is output. (see SQL
> below)
>
> select @out_v_errormessage = 'derived data' + '¬' + 'More Txt'
>
> BUT when the store proc is created in the database the ¬ changes to a 1/4
> character (see SQL Below)
>
> select @out_v_errormessage='derived data'+'¼'+ 'More txt'
>
> errrrr does anyone know why or a way around it - or should i just use and
> different char
>
> Thanks in advance
>
> Confused
>
> Murray

Relevant Pages

  • Raising SQL errors
    ... I am building an asp.net website which uses a SQL Server database. ... do data validation in the stored procedures and triggers, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Need help with Stored Procedures being called from Client Code.
    ... Although I totally advocate the use of Stored Procs for many reasons, ... Performance and Security aren't a slam dunk with procs - you can do the same ... you need to set a command for each operation that you are ... > I created the stored procedures for Select, Insert, Update and Delete ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Need help with Stored Procedures being called from Client Code.
    ... Each command property will get its own SQL Statement or procedure name. ... > but I have all those SQL statements in my stored proc!! ... >>> commandText property of the sqldataadapter or doesn't? ... >>>> I created the stored procedures for Select, Insert, Update and Delete ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How the frick do you call a stored procedure when using OdbcDataAdapter?!?
    ... you use Command objects to interact with the data source. ... you are going to be using stored procedures, ... connectionType to StoredProc. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: "Display Dependencies" not showing all dependencies
    ... do you have to recompile all stored procedures? ... This will generate the command for procs and functions, ... copy the output from the bottom pane to the upper pane or a new window. ...
    (microsoft.public.sqlserver.server)