Viewing 15 posts - 376 through 390 (of 1,988 total)
Stored Procedures always give a return value. What stored procedures do not always have is output parameters, which are different than function return values.
The return value from a SP is...
September 7, 2019 at 4:08 pm
Well if you have to set up SQL Server logins you can set them up with password expiration and change password on next login and give them a default password. ...
September 3, 2019 at 9:52 pm
My original post said it was basically fruitless. Not impossible tho I do question the absolute utility. My suspicion is that there is very, very little benefit or none at...
August 19, 2019 at 9:22 pm
Why pick the first thing he said? I chose the last thing! He had pretty much the same conversation we're having and already made the distinction between testing to make...
August 19, 2019 at 7:54 pm
Not really. Saying that I don't think you understand, is not an ad hominem attack. I also didn't mean it as an insult, just trying to figure out...
August 19, 2019 at 7:27 pm
[
The same reason you unit test anything? It's either the new development or it's something you're modifying.
New development and modifications should be tested over and over until they work...
August 19, 2019 at 6:19 pm
Yes I would 100% disagree with that, every object in the database does not interact with every other object in the DB in some exponentially spirally level of...
August 19, 2019 at 5:47 pm
What percentage of the total number of ways in which your data model could possibly be interacted with do you think your tests represent? If you have more than a...
August 19, 2019 at 5:40 pm
Just because an index has low usage doesn't necessarily mean it's useless. And the data in dm_db_index_usage_stats refreshes every time the instance restarts so there might be an index that...
August 19, 2019 at 4:25 pm
The old forums definitely did not. It was a simple toggle that was set each time you posted. No preference saved other than the last way you posted.
/shrug I...
August 16, 2019 at 4:26 pm
The problem with that is that it still doesn't consistently remember your last selected option for a particular topic. That to me is the bug.
We have never allowed...
August 15, 2019 at 6:49 pm
I would like to have a configurable default so that you could decide whether to have it automatically checked/unchecked.
Drew
There is. On the Edit Profile screen there's a checkbox...
August 14, 2019 at 8:16 pm
Speaking of website issues, is the bug where you have to unsubscribe from email notifications to a topic every time you reply going to be fixed?
August 14, 2019 at 1:01 pm
HAHAHAHA!!!! https://arstechnica.com/cars/2019/08/wiseguy-changes-license-plate-to-null-gets-12k-in-parking-tickets/
Should have gone for 'NULL'
August 13, 2019 at 7:01 pm
Compare 😛
SELECT Cast(Convert(nvarchar,(2032 + '-' + 1 + '-' + '05'))AS smalldatetime)
vs
SELECT Cast(Convert(nvarchar,('2032' + '-' + '01' + '-' + '05'))AS smalldatetime)
August 12, 2019 at 9:24 pm
Viewing 15 posts - 376 through 390 (of 1,988 total)