Using Microsoft R in Enterprise Environments
This article talks about using the the positive aspects of setting up R in enterprise environment and give instructions on first steps how to do it.
2016-08-25
2,360 reads
Enterprise environment
RE: Update with insert of zero
How about something like this:select CASE PATINDEX( '%[a-Z]%', col1) WHEN 0 THEN stuff('000',4-len(col1),len(col1),col1) ELSE stuff('000',4-PATINDEX( '%[a-Z]%', col1)+1,len(col1),col1) END from test1Where test1 is the table in question and col1 is the column you are working on.
2004-10-06
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers