Viewing 15 posts - 3,901 through 3,915 (of 7,636 total)
The problem is that your input file does not have either NULL or an empty string for that field, but a Space, which is different.
I do not see anyway that...
January 13, 2009 at 2:04 pm
Amol.Naik (1/13/2009)
The token size ranges from 500 thousand to 1 million.
Are you saying the you have 500,000 to 1,000,000 tokens to insert or that you have several tokens that...
January 13, 2009 at 1:24 pm
Right Gus. This proc only implements security against a possible SQL injection attack at this point. It does not implement any kind of Application Security. If user...
January 13, 2009 at 12:03 pm
mort.strom (1/12/2009)
If I go with a multi-tenant model, is it a difficult task to move to the single-tenant model if future success requires it?
If you implement it correctly, then it...
January 13, 2009 at 11:48 am
Scott T (12/30/2008)
For any math calculation avoid FLOAT use Decimal you will get Write result.:D
This is only true for Addition and Subtraction. For Multiplication and Division it is definitely...
January 13, 2009 at 11:12 am
Right Kent. It's a cool trick, but should only be used when truly desperate.
I have seen it cause such things as "undetectable deadlocks". These are really nasty because...
January 13, 2009 at 10:55 am
sarveshcnakhate (1/12/2009)
I want to know why it is not possible to do so? There must be some logical Reason/constraint.
Because like Excel and some other environments, SQL Server enforces a "strong"...
January 13, 2009 at 10:45 am
Do you mean when any JOB fails or when the Job Processor(SQL Agent) fails? These are completely different things.
And why don't you want to use the built-in mail facilities?
And...
January 13, 2009 at 10:33 am
Then you need to chain the conditions, like this:
(CASE WHEN SERVS like '% AV %' THEN '|AV|||1' Else '' END)
+ (CASE WHEN SERVS like '% AZ %'...
January 13, 2009 at 9:48 am
There is no supported way for us to make a system proc is SQL Server 2005.
January 13, 2009 at 8:57 am
Private Gripweed (1/13/2009)
This is probably all very basic.
Not really. It is not the kind of thing that I would expect a junior DBA to be able to do without...
January 13, 2009 at 8:55 am
Roy is right, Dynamic SQL is the standard solution for this kind of problem, but Injection is an overriding concern.
Here is how you can recode your simple example into a...
January 13, 2009 at 8:44 am
I am confused about what version of SQL Server you were running this on. Was it 2008 or 2005? (Note that this is a 2005 forum).
January 13, 2009 at 8:11 am
Viewing 15 posts - 3,901 through 3,915 (of 7,636 total)