Viewing 5 posts - 1 through 5 (of 5 total)
Christian Buettner-167247 (2/7/2011)
luciano furlan (2/7/2011)
We need an improvement over Sql language, that doesn't allow writing statements without the where clause.
No, we don't. Why would I write a where clause when...
February 7, 2011 at 1:05 am
Rob Fisk (1/30/2011)
SELECT m.*
--UPDATE m SET monkey = 'marmosette'
FROM monkeys m
WHERE MonkyID=2
That's the same way I always write updates/deletes. It is not perfect, but it is safer.
By the way it...
February 7, 2011 at 12:27 am
jinlye (1/26/2011)
February 7, 2011 at 12:15 am
It is a smart workaround, but it doesn't really solve the problem in an elegant way.
I miss a configuration on Sql server that states "Where Clause mandatory". For all tables,...
January 25, 2011 at 1:16 am
I compared the performance of the "while" solution with a fast_forward and a static cursor.
This are the results (average of 10 tests):
January 18, 2006 at 3:10 am
Viewing 5 posts - 1 through 5 (of 5 total)