Non repetable random number generation script

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: )

216 reads

Search any object across db's ..made simple

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: )

167 reads

Blogs

Daily Coping 3 Dec 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Homework – December 2020 – Participate in the Advent of Code.

By

Christmas. Depending on where you live it’s a big deal even if you aren’t...

[Video] Azure SQL Database – Import a Database

By

Quick Video showing you have to use a BACPAC to “import” a database into...

Read the latest Blogs

Forums

Disable Package Expression

By DinoRS

Hi SSC, I've got 2 Project Variables which I use to control wether a...

Inflow / outflow report per day

By milo1981

Hello, I have two simple tables: Invoices InvoiceID Date Value and PaymentsReceived PaymentID Date...

If SQL Agent Job takes longer than @X minutes, get notified.

By VoldemarG

If Agent Job takes longer than @X minutes, we want to be notified.  What...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers