Technical Article

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 […]

You rated this post out of 5. Change rating

2007-06-20 (first published: )

228 reads

Technical Article

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.

You rated this post out of 5. Change rating

2006-10-17 (first published: )

174 reads

Blogs

Azure SQL offerings

By

There are three Azure SQL products with so many different deployment options, service tiers,...

T-SQL Tuesday #183 Roundup

By

I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....

A Little Brainstorming with an AI

By

I was asked to do some a little thinking and brainstorming recently. Rather than...

Read the latest Blogs

Forums

Is Ransomware Fading?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Ransomware Fading?

How to Resolve SQL Server Database Stuck in Recovery Pending State

By Nisarg Upadhyay

Comments posted to this topic are about the item How to Resolve SQL Server...

A Simple Choice

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Simple Choice

Visit the forum

Question of the Day

A Simple Choice

I have this data in a table?

CatIDCatName
3Monitors
What is returned when I run this code?
SELECT CHOOSE(catid, 'Laptops', 'PCs') FROM dbo.Categories AS c
 

See possible answers