"A trigger procedure is created with the CREATE FUNCTION command, declaring it as a function with no arguments and a return type of trigger (for data change triggers) or event_trigger (for database event triggers)."
@dezso LOL, the guy who was arguing explicit conversions weren't necessary because it's in the documentation somewhere is too lazy to look at the documentation today :D
@AndriyM how is it not safe? Like can be confusing? You can name them, if you want like %(this_here)s and then use a dict with that key as the second parameter. And then there are some extras for doing more complicated stuff (partially in a more² complicated way)
LOL! "Coop's marketing analysts are reportedly targeting windows users. A source close to the director allegedly said 'Those idiots already paid for a thousand bugs mashed together - that's why we decided to call our product hamburgers 10!'"
ohh, that's too long to be funy. I should have just written "The bug-patties are marketed as "hamburgers 10"...
Anyone here have any experience with busy email servers? Our server can send out about 4 emails per second -- trying to get a feel for whether that is good or bad performance
I once sent myself thousands of SMSes. Wasn't fun hitting the phone SMS limit, deleting a few, then it filling up again. Think i got someone to delete them off the SMSC in the end
From Adam Bertand's "Bad Habits" series: What do BETWEEN and the devil have in common?
BETWEEN does an inclusive search with the bounds; that is, it's greater than or equal to the start and less than or equal to the end. Your query is the equivalent of select * from temp where a >= 2 and a <= 6
...
You could toss in
and a not in ('2','6')
or
and a not in ((select min(a) from temp),(select max(a) from temp))
..but only if you really hate your SAN administrator.
If you are running SSMS 2017 at least v17.6, there is now an option to turn this off. In the options dialog, go to "SQL Server Object Explorer" and then to "Commands". Under the "Drag/Drop" heading is a new option "Surround object names with brackets when dragged". By default, this is set to T...
@MaxVernon Dolden NULL (really!) from the deservedly famous Riedenburger Brauhaus
3
@Philᵀᴹ so no pub job anymore
@Philᵀᴹ I drank it once, after a bicycle race. It was very good, but possibly anything would have been. Here (in Germany) there are several better sorts.
The problem is that the old SQL Server Collations (i.e. those with names starting with SQL_) and the first two versions of the Windows Collations (the 80 series which came with SQL Server 2000 and do not have a version number in the name, and the 90 series which came with SQL Server 2005) are mis...
When searching for users there is a locations sub-dialog that lists the typical local machine, the domain (in my case corp) with the sublocations, and etc. Example this image from petri.com:
What determines the default location in this dialog? Even tho my machine is domain joined, it is default...