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)
227 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)
174 reads
2006-05-17 (first published: 2006-04-25)
262 reads
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
By Steve Jones
The more I work with the Data API Builder (DAB), the more I lean...
By Steve Jones
It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...
I want to replace all the oledb source editors as shown below with powershell...
New to Azure Data Factory, and as a starting point, we're trying to see...
Hi everyone, I need advice from the experts, this is the structure I created...
When does a column declared as SPARSE use no storage?
See possible answers