Viewing 15 posts - 4,621 through 4,635 (of 8,416 total)
george sibbald (3/30/2010)
Paul White NZ (3/30/2010)
Define 'developer'...:-Ppeople what code but can't restore databases! :-):-D;-)
I called myself a Database Developer for many years...:-P
March 30, 2010 at 11:07 am
matt32 (3/30/2010)
the OPENROWSET within Eli Leibas SP to create a view from the output of another SP:-)http://www.sqlservercentral.com/articles/T-SQL/68233/
this is cool and i use it often
Let's take a look:
1. The article...
March 30, 2010 at 11:04 am
Tough question for one measly little point.
March 30, 2010 at 10:40 am
Raju The Leader (1/18/2010)
March 30, 2010 at 10:34 am
Liked the use of TRY...CATCH (though checking XACT_STATE would be cool).
Disliked the loop.
On balance: not bad.
March 30, 2010 at 10:32 am
I do love an ambiguous/controversial QotD: the discussion is always fascinating.
March 30, 2010 at 10:28 am
It always amazes me how many people think only in terms of GRANT and DENY. Great question.
March 30, 2010 at 10:26 am
Hugo Kornelis (1/27/2010)
the strangely popular but really rather odd EXISTS 1 instead of EXISTS *...
I too find it odd, and always use the star syntax, but it turns out there...
March 30, 2010 at 10:22 am
The optimizer works on a logical tree of operations. That tree is derived from the text of the statement presented. The optimizer has many built in guaranteed-safe transformations...
March 30, 2010 at 10:19 am
ChiragNS (1/31/2010)
why is'nt BIT treated like other datatypes?
It is. The value supplied is implicitly converted to a BIT, according to the conversion rules.
March 30, 2010 at 10:14 am
Marry Krissmess (2/5/2010)
March 30, 2010 at 10:13 am
Everything that has been observed, regarding overflows, truncations, ELSE clauses executing and so on...is all documented in Books Online, under the following topics:
The various behaviours described in...
March 30, 2010 at 10:07 am
Viewing 15 posts - 4,621 through 4,635 (of 8,416 total)