This script will obscure email addresses from robots even ones that ignore the tags to not snoop. Usually robots that ignore the tags, and the robots.txt file are used by spammers. They pull down the SOURCE of your page and scrape the email addresses from them. This script breaks the mail href into its base […]
2003-03-23
125 reads
Lets you search all db objects for a string.EXECUTE spFindTextInObjects 'UNION ALL', 1 GOEXECUTE spFindTextInObjects 'XML EXPLICIT'GOEXECUTE spFindTextInObjects 'DECLARE%CURSOR', 1GOEXECUTE spFindTextInObjects '@@IDENTITY', 1GO
2003-01-29
289 reads
This procedure can search all columns in one or all tables for a specified string. Prints out the TableName.ColumnName that the string is found in...-- Example Calls-- EXECUTE spFindTextInColumns MyTable, 'tcart' --search a specific table-- -- EXECUTE spFindTextInColumns default, 'tcart' --search all tables BUG FIX : (2003/01/20) Changed SELECT @columnName […]
2003-01-09
989 reads
Yee Haa, as if we couldn't annoy our users more with message boxes, emails, and other friendly pop ups ;P here comes the net send. Has a test for success to determine if the send worked. If an invalid name is entered it can take a bit to fail, so don't use this from a […]
2002-12-18
373 reads
These are little more than wrapper functions for xp_regread and xp_regwrite, but lets them be callable from views, if you desire to do so.
2002-12-18
211 reads
This stored procedure lets you retrieve the environment variables from the server. you can pass in a partial name to get the variables that start with the partial match, or bblank to retrieve all the environment variables.
2002-12-18
609 reads
Purpose: To compare two strings with a supplied operator and return true if the strings evaluate to true using the operator provided. This is useful for stored procs to use instead of dynamic sql. YAY! Allowing for the operator and value to be passed in as parms. So that the user on the front end […]
2002-12-07
881 reads
Here is a script I wrote to automate updating of permission on a database. Often running as sa I forget to set the rights for objects when distributing db objects. It provides the capability to process only certain object types, and whether or not to print and execute the persmissions change or just print out […]
2002-11-22
479 reads
This script will return how many time one string occurs within another. It will only work on SQL 2K as it is a UDF, but it could be converted to a stored proc with a output variable for SQL 7.0.
2002-11-15
377 reads
This UDF will take a delimited string and split it into a table. It has an identity field that is provided solely for uniqueness on the rows, but that can be removed to improve the speed, and optimize it. Sample call :dbo.fnSplit(, )@Data - the string to split apart@Delimiter - the seperator string, if DEFAULT […]
2002-11-15
1,161 reads
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Comments posted to this topic are about the item Building a SQL Server Fleet...
Comments posted to this topic are about the item Smart AI Agents and Data...
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 [email protected] 8 [email protected]If I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers