Viewing 15 posts - 3,556 through 3,570 (of 7,484 total)
Hugo Kornelis (4/25/2013)
L' Eomot Inversé (4/25/2013)
April 25, 2013 at 12:31 pm
Good question and explanation.
Triggers that work only on single rows are a common problem, so anything that points out the pitfalls and warns people not to write them is a...
April 25, 2013 at 3:48 am
Maybe I'm slightly off topic here, but...
Once upon a time there was a principle that you could patent a new invention only if it was not something that others familiar...
April 24, 2013 at 12:15 pm
Really excellent question with a good clear explanation. More like thios onme, please!
April 24, 2013 at 10:09 am
jcrawf02 (4/24/2013)
Lynn Pettis (4/23/2013)
L' Eomot Inversé (4/23/2013)
Jeff Moden (4/23/2013)
April 24, 2013 at 10:01 am
Jeff Moden (4/23/2013)
Heh... to complicated. Just take Jason.A to work and let him entertain the kids with stories of GPO's as if they were dragons. 😛
That's too risky; if...
April 23, 2013 at 6:40 pm
SQLRNNR (4/23/2013)
jasona.work (4/23/2013)
Fracking place implemented / started enforcing a policy that prevents ANY accounts from having the "replace a process level token" privilege,...
April 23, 2013 at 6:28 pm
Hugo Kornelis (4/23/2013)
The first sentence of the explanation should probably have read "Instead of triggers can cascade regardless of the setting of the nested trigger server option."
yes, you are write....
April 23, 2013 at 5:22 am
cmorris1441 (4/20/2013)
Dird (4/20/2013)
Yeah I just tested it in my env 😮Also the commit shouldn't be within the transaction but I guess you copied it before I added it in~
Dird
Should...
April 21, 2013 at 10:12 am
IgorMi (4/20/2013)
HiYou can use this code to determine if a table has primary key (a condition for 2NF)
Actually having a primary key is a condition for 1NF. Of course...
April 20, 2013 at 6:33 pm
Ananth@Sql (4/19/2013)
Is It possible To Identify A Table By Seeing it Whether It is Normalized Or Denormalized?
In general no. Usually you have to know all the business rules that...
April 20, 2013 at 6:26 pm
m.rajesh.uk (4/20/2013)
First of all know the normalization forms and see whether they are implemented in table or not.
example: In your table...
April 20, 2013 at 6:14 pm
David Burrows (6/20/2012)
vinu512 (6/20/2012)
Cadavre (6/20/2012)
April 20, 2013 at 5:59 pm
Lynn Pettis (4/19/2013)
CREATE FUNCTION [dbo].[ifn_NumOccurrences]
(
@sourceString varchar(1000),
@searchString varchar(10)
)
RETURNS TABLE
AS
return
SELECT numTimes = (DATALENGTH(@sourceString) - DATALENGTH(REPLACE(@sourceString COLLATE Latin1_General_BIN2, @searchString, '')))...
April 20, 2013 at 5:51 pm
If the number of new students and the number of staff is always small, a simple loop adding one to whoever has the fewest students until there are no new...
April 20, 2013 at 4:28 am
Viewing 15 posts - 3,556 through 3,570 (of 7,484 total)