Re: stored procedure

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Daran Johnson (daranj_at_hotmail.com)
Date: 06/22/04 

Date: Tue, 22 Jun 2004 13:06:10 -0700

Mike,

If it's variable then use a varchar(x) where x equals the number of
characters - make sure it is enough characters for the strings you are
passing.

Don't use @@ as a prefix because that is used for system functions.

That should allow you to pass the string successfully.

Good Luck,
Daran

"Mike" <anonymous@discussions.microsoft.com> wrote in message
news:ucrymJJWEHA.3492@TK2MSFTNGP10.phx.gbl...
> I'm not sure if I'm in the correct group or not, but I need some help on
> something
> I'm new to this so,
> What I need to do is create a stored procdure were the server name is
being
> passed in to it from a Batch File.
> How can I make the server name a variable and an input field to the sp?
>
> I've tried
>
> CREATE PROCEDURE [dbo].[refresh_data] (@SERVER as nchar(20)) AS
>
> and
>
> CREATE PROCEDURE [dbo].[refresh_data] (@@SERVERNAME as nchar(20)) AS
>
>
>
> and it keeps failing
>
>
> thanks
>
>

Relevant Pages

  • Re: blank response from curl when posting form data
    ... under 800 characters, everything works. ... I tried passing the post data in strings, ...
    (comp.lang.php)
  • Re: jscript string size limitation in Ajax forcing a new architecture...
    ... The data comes from a stored procedure which, if a zipcode is, passed limits ... return - no WHERE clause - and we are looking at about 32k characters. ... Strings in JScript are limited to 2 billion characters or however much ... You shouldn't really eval code coming back from the server; ...
    (microsoft.public.scripting.jscript)
  • Re: jscript string size limitation in Ajax forcing a new architecture...
    ... Strings in JScript are limited to 2 billion characters or however much free ... You shouldn't really eval code coming back from the server; ...
    (microsoft.public.scripting.jscript)
  • Re: Why R6RS is controversial
    ... the semantics of the language, ... behavior of grapheme-cluster characters under most linguistic ... as the strings grow longer. ... Normalization is hideously complicated, and may require many ...
    (comp.lang.scheme)
  • Re: Unicode LISP??
    ... I'm not experienced with Common Lisp library, ... terms of strings rather than characters. ... have their representation upgraded if they are updated in place. ...
    (comp.lang.lisp)