Viewing 15 posts - 1 through 15 (of 454 total)
This is a very good reminder that data validation is not just limited to the straight format.
January 9, 2023 at 2:23 pm
Too funny. I wish it returned an error instead. One that says, "Dude! Just because this is 2022, you shouldn't expect anything different here!" 😀
Then use straight CAST. The...
January 9, 2023 at 2:21 pm
I think the answer could use a bit of clarification. This only works if the group is assigned a login in SQL Server.
Also, re: "A caveat here is that the...
June 23, 2021 at 4:55 pm
I beg to differ on the answers. The QOT basically said that all but the SET variable would reset @@ROWCOUNT to zero, however BOL states the following:
November 6, 2020 at 1:17 pm
This sounds like a nightmare.
One of the strengths of PASS, in my opinion, has been that while Microsoft is involved, the organization itself is largely free from being controlled by...
June 19, 2020 at 9:43 pm
technically, I would think that you would work a half day and then knock off, so if you normally start at 8 am your time, you would knock off...
December 24, 2019 at 2:30 pm
I've been dipping my toes into ADS on and off for a few years now. Each time I use it, I'm impressed by the new features and the improvements. I...
December 19, 2019 at 4:45 pm
If I create a contract in Service Broken, what are my options for sending directions of my message types?
Yeah, I really hate those broken services. 😉
Yeah. Not sure if...
May 17, 2019 at 2:14 pm
I do that while developing code, but move it to the end of...
July 12, 2018 at 4:47 pm
Bob Razumich - Wednesday, July 11, 2018 9:51 PMI am so looking forward to the arguments about where the semicolon should go exactly.
No...
July 12, 2018 at 4:26 pm
I've got to go with 2017. With SQL Server, Microsoft has done quite a good job of incremental improvements and removing cruft over the past 17 years.
So pretty...
April 10, 2018 at 6:31 am
Actually, the data is in a set of four extended properties for the column:
sys_information_type_id
sys_information_type_name
sys_sensitivity_label_id
sys_sensitivity_label_name
April 6, 2018 at 11:52 am
March 5, 2018 at 9:29 am
You think audit is hard? Wait until you're asked to do approval workflows -- where different users may have different rights to different attributes of the same entity...
As other posters...
February 27, 2018 at 1:16 pm
Viewing 15 posts - 1 through 15 (of 454 total)