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

2007-06-20 (first published: )

219 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.

2006-10-17 (first published: )

171 reads

Blogs

Daily Coping 30 Nov 2021

By

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

Fail activity in Azure Data Factory and Why would I want to Fail

By

(2021-Nov-30) I heard a story about a young person who was asked why she was...

Hiding Email with a Dynamic Data Masking Function–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

How to move Paas SQL Database from one subscription to another subscription

By jamessdba

Hi experts, Can some one please post procedure/Steps to move ( including Logins, Users)...

Arithmetic overflow error converting expression to data type datetime when selec

By JeremyU

I have such an issue. I want to select a column PDWEDT (it is...

inner join give me huge data when package id equal package id from another table

By ahmed_elbarbary.2010

I work on sql server 2014 i face issue when join two tables as...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers