We use function made in VB.NET for write file from T-SQL directly to disk, usualy XML. 🙂

Regards

You are true Nigel, thanks :-).

Here is now simple function:

ALTER FUNCTION [dbo].[IsAlphaNumeric](

@input varchar(100))

RETURNS bit

AS

BEGIN

DECLARE @isAN bit

SET @isAN= 0--non numeric

IF PATINDEX('%[^0-9]%', @input) = 0 BEGIN

SET @isAN = 1--numeric

END

RETURN @isAN

END

Or just test...

I expected function like that. Is string numeric or not.

CREATE FUNCTION [dbo].[IsAlphaNumeric](

@input varchar(100))

RETURNS bit

AS

BEGIN

DECLARE @i int, @max-2 int, @C varchar(1)

DECLARE @isAN bit

SET @max-2 =...

Definitely recommend this book (Defensive Database Programming) to anyone. I think that book is for begginers and for professionals :-). Also I recommend a set of seven "The Best...

Sorry LutzM, I didn't look well. I see now that problem with attribute "name" is already solved.

Thanks for your solution 🙂

Uros

You right LutzM.

Today I will try to implement your solution and later I will modify all existing imports. I think is much better. No nead to distribute "sqlxml.msi" to...

Thanks to respond, but I think you don't understand me.

I need to make XSD shema mapping file to import XML data to SQL Table. I use VB.

I already made mapping...

One question:

I always use CommandType=adCmdText and CommandText=mySQL.

MySQL is T-SQL statement or for execution stored procedures EXEC myStoredProc 'cParam1', nParam2, 'dParam3'.

Example:

If I don't need return data. 

.............

strSQL="EXEC myStoredProc '" & Param1...

This site is the best site on the internet and I hope that will be in the future too. ReedGate is a good company.

Andy, Brian and Steve I wish you the...

Sorry for delay, I was to busy.

I look regional settings of the account under witch the SQL server is running and I found source for my problem

Script work fine.  

My problem is solved.

But question why XP_CMDSHELL "DIR..." return date in wrong format still exist!?!?

Michael, very nice solutions. I will try it.

Will, my backup jobs delete files older then X days. My backup enable tree types of...

Sergiy, I agree with you but I use MSDE 2000 on local machine is no server there, just one machine with MSDE. When I see problem with date the first...

No, I can't write function becouse in SQL server date format is OK, so I newer know what format DIR function return, is '10.12.2006' october or december.

No, nothing help.

I need universal solutions, becouse I newer know what format user use on PC. Problem is in string. If I write a function which control the date string I newer...