2018-03-08
1,162 reads
2018-03-08
1,162 reads
Oracle Built in Function INSTR is a great function if you wish to locate a string or a subset of string in the nth place.
2016-11-17 (first published: 2016-11-04)
1,130 reads
Learn how you can find data in a string and extract it, no matter where it's located.
2016-03-10
32,518 reads
Finding characters/string before and after some character or pattern
2017-01-06 (first published: 2015-11-09)
138,266 reads
This In-line Table Valued Function returns a table with individual records parsed from a string.
2016-08-26 (first published: 2015-04-01)
4,785 reads
I had a requirement to produce a formatted currency string from within SQL server. I was able to build this scalar-valued function to meet the requirement.
2013-05-13 (first published: 2013-05-03)
1,001 reads
An in-depth analysis on how to store IPv4 addresses to achieve maximum efficiency and performance in both storage and queries
2009-08-19
8,629 reads
A stored procedure can query data in databases other than the database it exists in, via 3 part naming (DBName.DBOwner.TableName) or on linked servers via 4 part naming. CREATE PROCEDURE TestProcAsBEGIN SELECT * FROM SomeOtherDB.dbo.YourTableEND
2005-03-21
...oh, I see. Well, no wonder, I didn't understand. This acronym isn't usual here in Germany
2004-12-16
It's highly frowned upon and could cause problems. In SQL Server 7, triggers on system tables were not guarenteed to fire. I'd setup a job that runs every hour to look for this.
2004-11-30
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers