Viewing 15 posts - 1 through 15 (of 17 total)
To be honest it depends on alot of things. The size of your operation is a concern, some tools are great for a small desk, but lack the functionality a...
August 18, 2011 at 6:57 pm
Well, i don't need to know for this implementation, but i'm very interested for my personal knowledge.
Thanks.
March 30, 2011 at 7:44 pm
Hey Jeff,
Luckily, i only ever add one row at a time... which as i type it sounds a little RBAR... but that's how i'm fed the data.
ps: love the...
March 27, 2011 at 10:59 pm
Ok, i do laugh at myself sometimes.... 😀
so, the trigger was calling it
exec @NewIP = dbo.sp_Woodside_String_IP_Selection_V1 @IP, @NewIP = @test OUTPUT
When Ian did point out i should call like:
exec...
March 24, 2011 at 7:54 pm
Returns need to be an INT, that's why i got the conversion error. So i must be doing that wrong...
Changed the returns to selects and it works in the query...
March 24, 2011 at 7:39 pm
lol at me changing the the name of the sp in the first code block and not the second one... *sigh*.
anyways, i noted that i should have an OUTPUT in...
March 24, 2011 at 7:33 pm
good question! i recall them adding some new functionality to convert in 2k8 but had to research what that was 🙂
January 12, 2011 at 8:31 pm
great question today 🙂
i went right ahead and clicked 4... then read the question again... "active"... d'oh.
January 12, 2011 at 7:49 pm
janki_2886 (11/9/2010)
This was Question Direct from BOL, I have used same sentence as in BOL, Do you still think, its a grammer mistake.
There are hundreds of statements you could cut...
November 9, 2010 at 9:47 pm
yikes... i chose error while truncating due to the fact the table wasn't named correctly in the truncate statement....
:hehe:
October 20, 2010 at 10:11 pm
are you running an application from this DB?
i'd exercise caution before changing a collation from case insensitive... (if your Oracle was indeed case sensitive then there should not be an...
October 12, 2010 at 7:39 pm
Hugo Kornelis, you are a ninja!
i feel like i learned something now 🙂
i was pretty confused by the question, and even the explanation of why i got it wrong, but...
October 12, 2010 at 3:20 am
so, does the transaction actually run and get rolled back?
October 12, 2010 at 12:09 am
could you:
SELECT top(1) [ACTIVITIES.StartDateTime]
,ACTIVITIES.CategoryId
,ACTIVITIES.Id
FROM [Activities]
order by [ACTIVITIES.StartDateTime] desc
?
October 11, 2010 at 7:31 pm
This may be a silly question, but if you have access to Active directory, couldn't you get the username directly?
sAMAccountName...
I'm just thinking is someone has a different logon to their...
October 7, 2010 at 6:27 pm
Viewing 15 posts - 1 through 15 (of 17 total)