Posted by Jack Vamvas on 10/12/07 16:01

Could you post your stored procedure or code?
Are you able to get an output of the sql string that will be used, the one
that throws the error.



--

Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.com/SQL




<tatata9999@gmail.com> wrote in message
news:1192198893.793558.61740@v29g2000prd.googlegroups.com...
> Hi,
>
> SQL env: sql server 2000
> Target column of insertion: varchar(15)
>
> Case, a var is made up of a character of the following characters
> (random selection):
> A,B,C,D,E,$,!,%,^,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,&,*,(,)
> and a few numbers (random selection), and then
>
> var = ran1&ran2
>
> I'm experiencing intermit sql error
> Is it because I did not include the string with quotes like
> var = "ran1 & ran2"
>
> or the first random seletion may include special character and that
> may cause insertion error randomly?
>
> Probably the former is more likely. And I've added quotes for the
> var (programming language shouldn't really matter, int type usually
> without quotes while strings need quotes).
>
> What's your thought?
>
> Thanks.
>

• Next in forum: how to query for a column value that contains dashes
• Prev in forum: Would special character cause insertion problem?
• Thread view: Re: Would special character cause insertion problem?

[Reply to this message]