Viewing 15 posts - 10,546 through 10,560 (of 13,879 total)
dwain.c (8/10/2012)
There's always been a controversy over that acronym: http://www.allvoices.com/contributed-news/6036567-bodmas-is-used-my-millions-at-school-is-it-correct
Quoting that article:
Now if one uses BODMAS on...
August 10, 2012 at 2:56 am
dwain.c (8/10/2012)
Are you trying to say that Division has precedence over Multiplication and Addition over Subtraction?
These are at the same level - and so are evaluated in the order in...
August 10, 2012 at 2:42 am
dwain.c (8/10/2012)
derek.colley (8/10/2012)
Should follow BODMAS, i.e. Boolean, Division, Multiplication, Addition, Subtraction.BOL has division/multiplication at level 2 while addition/subtraction are at level 3.
So the BOL article shows that SQL Server confirms...
August 10, 2012 at 2:26 am
Maybe I am missing something, as this seems too obvious, but ... right-click the 'Constraints' node and select 'New Constraint'.
August 9, 2012 at 10:59 am
sql server developer (8/8/2012)
August 8, 2012 at 11:20 am
I'd say it was this bit
SELECT DATEDIFF(YEAR, EecDateOfOriginalHire, getdate()) from empcomp EC WHERE EC.EecEEID = E.EECEEID) as 'Yrs of Serv'
which is returning more than one value for one or more...
August 8, 2012 at 7:50 am
sql server developer (8/6/2012)
August 8, 2012 at 2:55 am
Daniel Bowlin (8/6/2012)
To change all the reports I would open the reports code (view code)...
August 6, 2012 at 2:13 pm
Krtyknm (8/6/2012)
Can you please provide some on idea on group the common word?
Example:
Code Desc
A1 ...
August 6, 2012 at 10:35 am
GSquared (8/6/2012)
Abu Dina (8/3/2012)
Street names in the UK tend to end with words like Street, Avenue, Crescent etc, if I...
August 6, 2012 at 6:41 am
Gazareth (8/6/2012)
Not sure why the NULLs are a problem though in...
August 6, 2012 at 6:39 am
Download Redgate's free SQL Search product & use that - it's very intuitive.
August 6, 2012 at 5:09 am
The implicit conversion suggestion is strengthened by the following:
declare @MyVarChar varchar(12) = '';
declare @MyVarcharInt int
set @MyVarcharInt = @MyVarChar
select @MyVarChar MyVarchar, @MyVarcharInt MyVarcharInt
August 6, 2012 at 3:48 am
mhk0m3 (8/6/2012)
August 6, 2012 at 3:24 am
Viewing 15 posts - 10,546 through 10,560 (of 13,879 total)