Posted by tatata9999 on 10/12/07 14:21

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: Re: Would special character cause insertion problem?
• Prev in forum: Re: How to Execute SQL Scripts using Batch file?
• Thread view: Would special character cause insertion problem?

[Reply to this message]