Hi,

a single quote is seen in sql server for separating text strings . For example

the following statement is valid

insert into tblX (A,B)

values ('one','two')

but if you have a quote...

Hi you could use the function replace to replace a ' (quote) by 2 quotes ''

strOut= replace(strIn,"'","''")

Hi in bol @@TRANCOUNT

Returns the number of active transactions for the current connection

Because every user that executes a stored procedure is a new connection you only get the value for...

Hi,

you could also try bcp with the -t parameter you could specify the field terminator.

regards,

Klaas-Jan

Thanks Andy.

How does ado then checks the login in the master database without using a select on sysxlogins ?

best regards,

Klaas-Jan

Hi,

use net stop mssqlserver

Edited by - Klaas-Jan on 07/15/2002 07:41:28 AM

select max(logdate)

from table

group by username

Hi, In the vb app you should return 1 in the error handling, this way the job knows that the vb failed and you can investigate why. (If you do...

Hi Richard,

I usualy write down comments first. So i create a empty main with all the required steps in comment. For the notation i use simple one liners what the...

Hi, good article, i agree that proper formatting makes code more readable. I think comment is also very important, will that be described in a next article?

Klaas-Jan

Hi,

from bol: OPENROWSET does not accept variables for its arguments.

In the xp_logininfo in sql 2000 they used an other solution.

Hi, what you could do is move the insert statement in a separate stored procedure. And make the cursor read only ( i don't have sql 7 bol at hand...

select empno,max(empdate)as empdate

from tblX

group by empno

Hi, you can do that with enterprise manager. If you want to do this with qa then you have to drop and recreate the table.

Hi Marcel, if you want to write customized error messages to the eventlog you can select the always write to windows event log.

The system messages severity higher then 19...