THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » T-SQL » Scripts   (RSS)
Showing page 2 of 2 (18 total posts)
  • Tokenize UDF

    Yes, another string splitting UDF from a guy who's obvioiusly become obsessed with TSQL string splitting. This time we delve into a mysterious world that I call, ''Tokenization.'' So what is Tokenization? It's a word I made up for this problem. But what is it, really? It's splitting up a string based on a delimiter -- in this case, a ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 12, 2006
  • "Reflect" a TSQL routine

    Ever want to see the text of a stored procedure, function, or trigger -- or manipulate the text in some way? sp_helptext works, sort of. But I really don't like the way it handles large procedures (> 4000 characters). They seem to end up with some strangely wrapped lines and other side-effects that aren't too nice. So I decided to roll my ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 12, 2006
  • Script out PKs/UNIQUE constraints and referencing FKs

    In the course of my work, I occasionally need to cluster a primary key that's nonclustered, or go the other way, or make some other modification to a primary key... But it's a hassle! All of the foreign keys need to be dropped, the PK needs to be dropped, and then everything needs to be re-created. Scripting all of that stuff out can be very ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 12, 2006
  • Pattern-based split string

    ''hickymanz'' asked in the SQL Server Central forums for a method of counting unique words in a text column. Wayne Lawton recommended using a string split function, which was a good idea, but not quite adequate for the job in my opinion. Typical string split functions, like this one that I wrote can handle only a single delimiter, e.g. a ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 12, 2006
  • Validate a URL from SQL Server

    File this one in your folder of things you should probably never use -- but maybe, some day, in an emergency, you'll need this. I see posts requesting this functionality all the time. ''How do I validate a URL in SQL Server?'' Not just the string, but the URL itself -- how can we find out if it's valid? Thanks to the Object Automation ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 12, 2006
  • Counting occurrences of a substring within a string

    I have absolutely no idea why anyone wants to do this, but I keep answering the same question in forums: ''How do I count the occurrences of a substring [note: usually comma] within a string?''   In an effort to thwart carpal tunnel syndrome, I have created the Ultimate Substring Occurrence Counting UDF. ... And here it ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 12, 2006
  • Splitting a string of unlimited length

    There are many techniques for splitting a string in T-SQL (in other words, taking a character-delimited string and producing a table of the values), the best of which are encapsulated in Erland Sommarskog's famous article. My favorite of his string splitting techniques is adapted from a previous example that was created by Anith Sen. Both ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 12, 2006
  • Pattern-based replacement UDF

    As a personal challenge, I decided to write a UDF that will work just like T-SQL's REPLACE() function, but using patterns as input. The first question: How does REPLACE() handle overlapping patterns?  SELECT REPLACE('babab', 'bab', 'c')-------------------------------------------------- cab(1 row(s) affected)SELECT REPLACE('bababab', ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 12, 2006
Privacy Statement