search

jeffshumphreys / MySQLCLRFunctions

Free SQLCLR functions tested on SQL Server 2019. That are used.
MIT License
7 stars 1 forks source link

Refactor names to be suffixed where meaningful "-S", "-C", or "-X" #3

Closed jeffshumphreys closed 9 months ago

jeffshumphreys commented 4 years ago

So for instance, a newer function "Near" i suffixed "NearX" to make it abundantly clear that it takes a pattern and not a string.

Considering using "-Cs" for a list of characters.

jeffshumphreys commented 4 years ago

Making progress. Of course, this breaks any actual SSMS SQL code that references these, but I was discovering that "FirstWordBefore('.')" was ambiguous from a user perspective. Is that FirstWordBefore the character '.'? or FirstWordBefore any character? That last would be a bit stupid, but then if it was a RegEx pattern, then it would return an empty string every time, and debugging that would be an exercise in working for the government.

jeffshumphreys commented 4 years ago

Figgered it out. Create here. Then refresh your linked project, shows up as is:open, then drag to correct stage channel.