Viewing 15 posts - 331 through 345 (of 374 total)
Can you confirm that this is what's happening?
You wrote and tested your trigger on the database table in Management Studio, probably using sa or equivalent rights.
When someone inserts into the...
March 10, 2011 at 5:58 am
Are these char or (n)varchar fields? Or some other data type?
March 10, 2011 at 5:26 am
Kit G (3/9/2011)
March 9, 2011 at 6:59 am
Tom.Thomson (3/8/2011)
Kiara (3/8/2011)
Koen Verbeeck (3/8/2011)
(who for some bizarre reason love to work in an industry...
March 9, 2011 at 5:10 am
Koen Verbeeck (3/8/2011)
(who for some bizarre reason love to work in an industry dominated by...
March 8, 2011 at 11:07 am
GSquared beat me to explaining the way the where clause evaluates, but I think you have another logic bomb at the moment.
2010-03-15 12:53:00.000 is not equal to 2010-03-15 00:00:00.000
So...
March 8, 2011 at 9:10 am
Jeff Moden (3/7/2011)
Kiara (3/7/2011)
But... but... it's *pretty*! I just wanted to look at it... really! We have such *boring* money over here in the States...
-Ki
BWAA-HAA!!! I will be happy...
March 8, 2011 at 5:14 am
LutzM (3/7/2011)
SQLkiwi (3/7/2011)
Stefan Krzywicki (3/7/2011)
Just send him money! If he gets enough he may feel guilty and decide he has to write a book.
An excellent suggestion. 🙂
I'm not going to...
March 7, 2011 at 12:46 pm
SQLkiwi (3/4/2011)
Exciting day - just had my first Simple Talk article published:http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/
Wow - what a great article! Congratulations - and thank you for taking the time to write it!
-Ki
March 7, 2011 at 11:53 am
Craig Farrell (3/4/2011)
Kiara (3/4/2011)
Steve Jones - SSC Editor (3/4/2011)
I would have sworn that the RAID 1+0 was 4 in Wikipedia, and I have submitted a correction.
The really funny part about...
March 4, 2011 at 10:38 am
Steve Jones - SSC Editor (3/4/2011)
I would have sworn that the RAID 1+0 was 4 in Wikipedia, and I have submitted a correction.
The really funny part about it? It seems...
March 4, 2011 at 9:21 am
Sharon Kumar (3/4/2011)
I have a table results with
CompanyTeamStatus
----------------------------------------
Wiprogroup1finished
TCSgroup1Solved
Wiprogroup2solved
GEgroup2finished
TCSgroup1not solved
Satyamgroup3not solved
I need results ouptlike
group1group2 group3
com count(com) solved finished not solvedsolved finished notsolved solved ...
March 4, 2011 at 6:15 am
Are you looking for sys.dm_exec_query_stats?
-Ki
March 4, 2011 at 5:31 am
I'm just jumping in here to watch this thread - I'm going to have to figure out how to do almost the same thing in the near future. So I'm...
March 4, 2011 at 5:26 am
Viewing 15 posts - 331 through 345 (of 374 total)