Global Database Field Search
Search all text fields in a database for a literal string.Outputs SQL statements to query analyser window, which can then be run in a new window.
2004-02-10
173 reads
Global String Search & Replace In All DB Fields
Stored procedure to search every field in the database for a string literal. Run the stored procedure in Query analyser, which will output sql statements to do the search. The output of these searches will be the update sql, which again should be pasted into a query analyser window. As the stored procedures do not […]
2004-02-10
243 reads
Blogs
Quick Blog: Making the Power BI PowerShell cmdlets easier to use
By Aaron Nelson
One of the top reasons I love PowerShell so much is that from the...
Trouble writing? Join the club. #JustWriteTech
By Jen McCown
I was talking with a couple of excellent SQL people* recently, and we were bemoaning...
Check Query Progress with Live Query Stats
This is something I touched on back in 2017 a little after the Live...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
update table b if b.time falls between any of table a rows start/stop
I'm trying to find a way to rewrite this dusty old cursor set based,...
Check if number exists in a column
Hello, I am pulling some address data from a legacy system and it has...
Ask SSC