Viewing 15 posts - 16 through 30 (of 831 total)
I've run into the "unable to open E:\..." error when installing SQL Express on a domain controller, and the only way I found to fix it was to specify that...
May 24, 2016 at 1:59 am
crmitchell (5/17/2016)
With SQL going to be supported on Linux in the future this may become a lot more complicated as you may need to start considering whether you are running...
May 17, 2016 at 3:32 am
roger.plowman (5/10/2016)
And when you retire and look back on your career, your victories will be yours, your failures will be yours, and no one else will ever know what you...
May 10, 2016 at 7:09 am
TomThomson (12/11/2015)
It's a pity that the result value -1 is used for three different things: (i) errors (ii) no rows were affected and (iii) no rowcounts were returned (ROWCOUNT...
December 11, 2015 at 3:37 am
sknox (12/10/2015)
Well, a query is a question, which implies an answer.
So "NonQuery" implies you never asked the question in the first place, which is exactly the point I was making....
December 10, 2015 at 10:03 am
Always thought this is a rather badly named function--ExecuteNonResults would be better, IMHO. ExecuteNonQuery implies it's not actually going to run the query, to my mind.
December 10, 2015 at 6:53 am
Rune Bivrin (11/25/2015)
Where can I buy SQL Server 2015?:hehe:
It's only available on November 31st, so you'll have to be quick. 🙂
November 25, 2015 at 5:42 am
Toreador (10/30/2015)
Only if you take TRY_CONVERT to mean the Try and the Try Conversion.
I take it to mean just the Try Conversion (so 2 points).
Exactly as I did, clearly this...
October 30, 2015 at 4:21 am
Well, I knew something would go wrong with the view, but apparently not the specifics of how it would go wrong. Means I learned something, which is always a plus.
October 29, 2015 at 5:00 am
saurabhsharmadcsa (10/28/2015)
Correct Answer for this question is the query would return 3 rows
No it isn't, because the default collation for a SQL server install is for a...
October 29, 2015 at 4:06 am
Looks like there's sometimes an advantage to SQL Server Central e-mails getting stuck for hours in our spam filter, it means I missed all this and got given the correct...
October 28, 2015 at 8:36 am
I misinterpreted the subdirectory question--I thought it meant you couldn't have more than 255 subdirectories at each level, rather than the nesting level? There used to be hard limits on...
October 6, 2015 at 2:58 am
Luis Cazares (9/30/2015)
When I use Try_Convert(int, '+') it gives me 0 instead of NULL.
That's probably because '+' converts to 0 using regular CONVERT, so it doesn't count as a value...
October 1, 2015 at 3:21 am
Eric M Russell (9/28/2015)
For example, if you have a VarChar column that should only contain values that are covertable to a specific data type (ie: Int or Date), then consider...
September 28, 2015 at 7:05 am
Kristen-173977 (9/27/2015)
September 28, 2015 at 2:10 am
Viewing 15 posts - 16 through 30 (of 831 total)