This Function Enables the user to retrieve the Last Index of the character/string in a predetermined string.Eg If you want search for the Last Occurance of 'SQL' in 'SQL SERVER2000 USES ANSI SQL' thenSELECT dbo.LastIndexOf('SQL SERVER2000 USES ANSI SQL','SQL')will return 26.Tested Only in SQL SERVER2000
2004-03-25
2,814 reads
This Function is a small script to retrieve the age of person based on date of birth to a particular date.Eg.select dbo.GetDateofbirth ('01/01/1975',GETDATE())RETURNS29Years 2Months 24Days that is the age.TESTED only on SQLSERVER 2000
2004-03-25
410 reads
Function RJZeroN is used for formatting integer numbers as right-justified strings with leading zeroes according to a specified size (max 20 characters which will hold the largest BIGINT value). A NULL value is returned if the formatting cannot be done according to the values specified.Example: Format a 3-digit number as a 7-character numberstring with leading […]
2004-03-24
965 reads
SQL 7.0 and 2000 modified version of Rodrigo Acosta (racosta) Argentina Script that enable,disable or list all the Triggers in the given database. If enable or disable are specified, finds all the triggers of all the tables and enable or disable them, After that, it list all the triggers with it´s current state. If List […]
2004-03-19
174 reads
With this function you can recover from your table all the password save encripted with another function posted before (check this site to find the script). The function recieves an encripted password and changes every character to return the right password.
2004-03-18
543 reads
If you need to save password for you application in tables, with this function you can save them encripted. And with another published function (check the page to find the script) you can desencript it. The function receives the password, modifies every character and returns the encripted password.
2004-03-18
602 reads
Like sp_who2 but this one let's you specify to filter by spid, login, hostname and dbname.Like any system procedure, can be executed from any database.
2004-03-18
9,624 reads
This script drop all indexes from table, including Primary Key contraint. First it del nonclustered indexes, then clustered and at last - drops PK contraint. This scirpt is useful, when you need drop all indexes, like when doing ETL process.
2004-03-17
543 reads
If you need to alter existing datatypes in the event of a SQL Server Datatype issue for capacity planning or conversion process this simple schema script may come in handy
2004-03-15
136 reads
This function calculates the time difference between 2 datetimes and displays the results in the following format:H,HHH,HHH:MM:SSThe return is a 15 character field that is left padded with spaces so that the field becomes right justified. This makes the colons line up for easy reading. Commas are automatically added as thousands separators as needed by […]
2004-03-14
440 reads
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
Say you need outside help. You’ve exhausted all the things that you could do...
I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...
Not seeing a 2025 forum, it looks to me the site will not going...
I installed a new SQL server 2025 Enterprise developer edition for our development environment....
Comments posted to this topic are about the item How Clustering can be Used...
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers