Viewing 15 posts - 151 through 165 (of 219 total)
mohammed moinudheen (3/9/2010)
I wrote this because most of my colleagues are still working on SQL server 2000. Not sure, when they plan to migrate to 2005 or higher.
Thank you...
March 9, 2010 at 9:16 am
sknox (3/8/2010)
I'm quite surprised that, at the time I answered the question, approximately 3/4 of people got this question wrong.
Do you think this is because lack of knowledge? I think...
March 9, 2010 at 3:34 am
erwin.oosterhoorn (3/8/2010)
bouarroudj Mohamed (3/8/2010)
CONVERT works across all platforms & has more capabilities in SQL Server is also true
That is what I am looking at as well, does this not mean...
March 9, 2010 at 3:26 am
most of us are still working on older, SQL Server 2000 servers
Are there any statistics on this?!
March 9, 2010 at 12:19 am
petertrast (3/3/2010)
Christian Buettner-167247 (2/5/2010)
I wonder why there is no DDL trigger available to capture this of event...
Because it is a DML event, the structure of the table is not changing,...
March 3, 2010 at 1:43 pm
kaspencer (3/2/2010)
Otherwise, then let's call it a decimal comma
Maybe you'll be surprised by the fact that the decimal separator IS called 'decimal comma' in many countries: http://en.wikipedia.org/wiki/Decimal_separator#Countries_using_Arabic_numerals_with_decimal_comma 🙂
Here's a quote...
March 2, 2010 at 2:55 am
Oleg Netchaev (3/1/2010)
March 1, 2010 at 12:51 pm
skjoldtc (3/1/2010)
If stored procedures are never saved to disk
The explanation says that stored procedure plans are never saved to disk. Of course, stored procedures themselves are saved to disk, otherwise...
March 1, 2010 at 9:10 am
I think the typo is quite obvious.
Thanks to the author: the question was very useful to me, due to the question I learned the new word 'sargable' 🙂
February 26, 2010 at 6:42 am
bc_ (2/25/2010)
is there an advantage to using a fixed width font? or is it personal preference?
Fixed-width fonts allow to adjust and beautify a piece of code easily.
Simple example (Courier...
February 26, 2010 at 2:15 am
bc_ (2/19/2010)
Here is the actual code
It is very interesting to see a proportional font (looks like Arial) on the screenshot 🙂 Do you really use that font for everyday coding...
February 25, 2010 at 1:06 am
kaspencer (2/22/2010)
Good question. And it also raises a further point in my mind ...Is there a need to standardise numerical representation across every locale ?
Is there a need to...
February 22, 2010 at 7:04 am
ISNUMERIC() function always ignores commas while validating data
The question is good, but the explanation is wrong. In some cases commas are not ignored:
SELECT ISNUMERIC('-1') -- the result is 1
SELECT ISNUMERIC(',-1')...
February 21, 2010 at 5:32 pm
SanjayAttray (2/6/2010)
Triggers are for INSERT, UPDATE, or DELETE only.
Correction:
DML triggers are for INSERT, UPDATE, or DELETE only.
There are also DDL triggers for a wide variety of DDL events. I answered...
February 10, 2010 at 3:28 am
Viewing 15 posts - 151 through 165 (of 219 total)