Some time back i had the requirement for a SP which will give non repeatable random numbers with in a range. Following SP accepts a range and gives the random numbers. Once the numbers are exhausetd NULL, will be the out put. In this case user can restart the random number generation by passing 1 […]
2007-06-20 (first published: 2006-03-29)
244 reads
I just saw a script on this site for object search across the db's. I have written an alternate version with sp_msforeachdb undocumented sp which is much simpler.This avoids a lot of code and dynamic sql.Replace "object_name" with the name of the object which needs to be searched across the databases.
2006-10-17 (first published: 2006-03-29)
182 reads
2006-05-17 (first published: 2006-04-25)
269 reads
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
Comments posted to this topic are about the item What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers