Viewing 15 posts - 2,956 through 2,970 (of 7,484 total)
Lynn Pettis (10/28/2013)
October 28, 2013 at 7:50 am
marlon.seton (10/28/2013)
Will dropping the table remove the open transaction on the table?
No - the transaction is still open, and the table is not dropped until the transaction is committed: subsequent...
October 28, 2013 at 5:22 am
Nice question.
Has one small problem though: the code leaves a transaction open - nothing is actually committed.
It's clearly stated in BOL:-
Although each COMMIT TRANSACTION statement has a transaction_name parameter, there...
October 28, 2013 at 3:15 am
Jeff Moden (10/26/2013)
L' Eomot Inversé (10/24/2013)
wolfkillj (10/23/2013)
I've published my first technical blog post. I'd appreciate any feedback from this group on both the technical aspects and the writing. Thanks, everyone!
Nice...
October 26, 2013 at 1:46 pm
wolfkillj (10/23/2013)
I've published my first technical blog post. I'd appreciate any feedback from this group on both the technical aspects and the writing. Thanks, everyone!
Nice article. I liked seeing...
October 24, 2013 at 8:08 pm
opc.three (10/23/2013)
You're conflating multiple issues. There is a difference between trusting someone to do all operations within...
October 24, 2013 at 5:13 pm
Remarkably easy for a 2 point question.
October 22, 2013 at 10:44 am
Trying to do something for the UK (as opposed to just for England) is going to be quite hard. It is very common in Scotland for first names to...
October 21, 2013 at 5:34 pm
I certainly don't like the article referenced, it seems to me that it is a heap of assertions for whose credence no basis is offered. Yes, scalability needs to...
October 21, 2013 at 3:59 pm
Revenant (10/20/2013)
Koen Verbeeck (10/20/2013)
GilaMonster (10/18/2013)
Koen, you are awesome. 🙂Koen Verbeeck (10/18/2013)
hoseam (10/18/2013)
I don't have a backupSorry to hear that.
Let this be an incentive to implement a backup plan.
:hehe:
I know I...
October 20, 2013 at 8:45 pm
Mike John (10/18/2013)
October 19, 2013 at 7:29 am
The schema definition seems odd. You might find that things become easier if you change the definition of the Employee table to be something like
Employee (user_id...
October 19, 2013 at 6:32 am
If the requirement is to remove trailing spaces and all trailing non-alpha-numerics Luis code is what's needed; but it seems a bit heavyweight if the requirement is just to eliminate...
October 19, 2013 at 5:42 am
I won't comment on cursors, as I see no point in thinking about them.
Table however is clearly not a datatype; associated with any datatype is the somain for that datatype,...
October 18, 2013 at 2:54 pm
Viewing 15 posts - 2,956 through 2,970 (of 7,484 total)