Viewing 12 posts - 1 through 12 (of 12 total)
I have never read the statement "do not use cursors" in any other way than interpreting it as "do not use row-by-row operations, use set operations instead".
So I do...
June 1, 2015 at 2:13 am
I think you are absolutely right.
Once I was asked to take over a different position in our company and I refused at the time, I did not really want...
January 20, 2014 at 7:55 am
First, it is actually not true that an expression containing NULL evaluates to FALSE.
It evaluates to UNKNOWN.
A WHERE clause filters out all UKNOWN values, and that is why you...
January 20, 2014 at 7:39 am
I checked the sys.login_token view but it won't help me because the Windows group in the working database is a different one than the group in the non-working one.
January 3, 2014 at 8:09 am
@GregEdwards - there has been no movement of this database nor any change in AD. The database in question was created on that server. The older databases did come from...
January 2, 2014 at 12:06 pm
The error log shows: Error 18456 Severity 14 State 38
According to this site
error state 38 indicates:
"The database specified in the connection string, or selected in the...
January 2, 2014 at 2:42 am
jcb - thanks, I checked, in fact there are no triggers anywhere in the database. Actually in the production database the AccountID column is an Identity column, sorry, I did...
November 18, 2013 at 1:57 pm
Lutz - I am going to rewrite it set-based, sure.
As I see it, cursors are really meant for interaction between SQL Server
and applications which just cannot understand set-based operations.
November 17, 2013 at 6:03 pm
Here is some test code.
I am afraid you won't find any problem on the test code, as I could not do so myself. It occurs only in my production...
November 17, 2013 at 2:34 pm
Well, I guess you're right, and I agree. I inherited the code and yes, it won't stay this way.
But my question is rather why does something like this occur -...
November 17, 2013 at 9:54 am
what program creates your dBase files?
Newer version of dBase, and their clones such as Visual Foxpro, have support for converting tables to XML files.
Otherwise it is quite elementary,...
February 17, 2010 at 9:57 am
Cannot download your stored procedure - link is broken?
February 17, 2010 at 6:21 am