Viewing 15 posts - 16 through 30 (of 40 total)
I need to cite where I got this trick from, but try this:
DECLARE @stmts TABLE (id INT IDENTITY, stmt NVARCHAR(MAX), PRIMARY KEY (id)) -- your table
insert into @stmts (stmt)
select 'print...
March 25, 2009 at 12:59 pm
Word!
Thanks. I didn't think about that before. That actually explains the behavior in my actual code.
But I'm still curious if you know off hand any documentation that states exactly what...
March 23, 2009 at 8:41 am
@@version=Microsoft SQL Server 2005 - 9.00.4211.00 (Intel X86) Jan 30 2009 13:43:44 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790:...
March 23, 2009 at 8:35 am
Ok, This is the actual problem I think I am having with my code. I've seen other people write it this way before, so I can't understand why it's wrong/
CREATE...
March 23, 2009 at 8:34 am
Yes that does help.
Is there a reference anywhere as to what errors a CATCH traps exactly? I was under the impression it was almost if not all errors.
Also, if you...
March 23, 2009 at 8:30 am
Good good,
Whenever I try these with the actual table, I get the following error:
Msg 8167, Level 16, State 1, Line 1
The type of column "app_sys_group_cde" conflicts with the type of...
February 18, 2009 at 1:00 pm
I'm guaranteed to only deal with one row at a time - We're still working out the exact structure of how the data comes in and all but it's not...
February 18, 2009 at 12:26 pm
The pain to wordcount ratio on that post was obscene.
January 14, 2009 at 12:45 pm
That solution makes a lot of sense. Here's something I've been thinking about:
I will place a trigger on the database (actually on every table) and anytime a user executes an...
January 14, 2009 at 12:00 pm
GSquared, you're on the right track.
A simple pending flag like that wouldn't solve the issue of records that were, updated.
Maybe a multi-option flag, such as
0 = Live or production record
1...
January 14, 2009 at 11:10 am
Not quite what I was looking for.
What I'm looking for is help designing a database in which changes to any of the tables (inserts, updates, deletes) are not applied until...
January 14, 2009 at 11:02 am
Out of curiosity, what would you have suggested?
November 14, 2008 at 6:20 am
I have a table of applications my organization uses, and unlike parents, my organization doesn't love them all the same.
These applications were ordered by their recovery time but the list...
November 7, 2008 at 6:12 am
Viewing 15 posts - 16 through 30 (of 40 total)