This UDF takes a delimited string and parses it into "words" which are returned as rows in a table. The table returned indicates the position of each element in the source string, and converts values to integer and numeric formats if possible.The script contains examples on how to use the function.the original version was written […]
2005-09-26 (first published: 2004-08-10)
650 reads
This function will increment the given alpha numeric string in sequential order up to 100 characters. (The length can be easily modified)
2005-09-22 (first published: 2005-02-14)
2,638 reads
Here's a quick and dirty function for parsing strings based on a delimiter (As in a varchar field with comma delimited text). I'm hoping for feedback on a more efficient means of doing this.Also,4 functions for comparing two delimited lists of strings. Many may ask why these are needed, but that's a very long explanation […]
2005-09-21 (first published: 2004-08-25)
289 reads
This is a function that takes a start date and end date as parameters and returns the number of weekdays (Monday to Friday) in between. This function assumes that Sunday is set as the first day of the week. Adapted from a vb function that I wrote to calculate standard salary costs for billing purposes. […]
2005-09-19 (first published: 2004-10-16)
316 reads
This script will document tables (including constraints and triggers, row counts, sizes on disk), views (including all used fields), stored procedures (including used fields and parameters), database users, database settings and server settings.This script has been cobbled together from several others found on this site, so they deserve the recognition, not me 🙂Simply execute it […]
2005-09-16 (first published: 2004-09-02)
408 reads
Use this script to navigate your recordset a page at a time containing a specific number of records and in a specified order.I use the supplier table of the northwind Database to demonstrate thisReturn List of suppliers, ordered by supplier desc, 10 records at a timeexecute prc_lov_SUPPLIERS "", "Suppliers", 1, 1 ''Page oneexecute prc_lov_SUPPLIERS "", […]
2005-09-08 (first published: 2002-05-02)
254 reads
Quando você restaura um banco ou 'atacha' ao seu servidor de outro servidor, pode ocorrer de o usuário que existe no banco não sincronizar com o login do SQL server anteriormente criado com DBO desse banco, então esse script faz exatamente isso, pega o SID do SQL e dá um UPDATE no SID do usuário […]
2005-09-06 (first published: 2005-08-30)
373 reads
This might not be the fastes script, in the world but it takes care of the McDonalds, O'Brian's, MacPherson's and the Jens-Michael's of the world.
2005-09-05 (first published: 2005-08-31)
318 reads
Many users during the process of insert or update get the following warning issued by SQL ServerWarning: The table 'TABLE NAME' has been created but its maximum row size (XXXX) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length […]
2005-09-02 (first published: 2005-08-25)
359 reads
An easy script that gives you the information of all non-system databases, its size and all the configuration options that you can get individually with DATABASEPROPERTYEX function.
2005-09-01 (first published: 2005-08-25)
1,140 reads
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Referrals have never been more important in the job market. They’re no longer nice...
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers