Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Random Numbers Rss

   Items 1 to 19 of 19   
 

Exploration of SQL Server 2016 Always Encrypted – Part 3

In this third article of the exploring SQL Server 2016 Always Encrypted series, Greg Larsen looks at the differences between an Always Encrypted column that uses an encryption type of Deterministic and those that use encryption type of Randomized.  Read more...
By Additional Articles 2016/02/08 | Source: Database Journal | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 2,903 reads

Random Data Generator

A query to generate random values for several different data types.  Read more...
By Peter Wehner 2015/07/31 | Source: SQLServerCentral.com | Category: random numbers
Rating: |  Discuss |   Briefcase | 1,302 reads

Generating A Password in SQL Server with T-SQL from Random Characters

Dallas Snider explains how to use T-SQL to generate a random password that meets an organization's password requirements.  Read more...
By Additional Articles 2015/05/06 | Source: MSSQLTips.com | Category: password
Rating:  Rate this |   Briefcase | 7,417 reads

A More Versatile SQL Server Random Number Function

Image a situation when you use the SQL Server RAND() T-SQL function as a column in a SELECT statement, and the same value is returned for every row as shown below. In this tip, Dallas Snider explains how you can get differing random values on each row.  Read more...
By Additional Articles 2015/04/02 | Source: MSSQLTips.com | Category: random numbers
Rating:  Rate this |   Briefcase | 9,677 reads

Generate a random password

If you ever need a quick way to generate random passwords, this is a pretty useful way to do so.  Read more...
By Gaby Abed 2013/05/15 | Source: SQLServerCentral.com | Category: random numbers
Rating: |  Discuss |   Briefcase | 3,292 reads

Random DEFAULT string for a column using CASE and NEWID

Sometimes you just need to populate a CHAR/VARCHAR column for testing with a random selection of string literals at table CREATE time. Here is a quick and easy script.  Read more...
By Bill Leung 2012/06/14 | Source: SQLServerCentral.com | Category: random numbers
Rating: |  Discuss |   Briefcase | 1,086 reads

Generating Test Data: Part 2 - Generating Sequential and Random Dates

Part two of this fantastic series from Jeff Moden looks at generating date data, something which can be handy for any number of testing purposes.  Read more...
By Jeff Moden 2012/04/25 | Source: SQLServerCentral.com | Category: test data
Rating: |  Discuss |   Briefcase | 5,465 reads

Generating Test Data: Part 1 - Generating Random Integers and Floats

Learn how you can easily generate large amounts of test data efficiently in this new series from Jeff Moden. Part 1 covers integers and floating point values.  Read more...
By Jeff Moden 2012/03/26 | Source: SQLServerCentral.com | Category: data generation
Rating: |  Discuss |   Briefcase | 7,521 reads

Raffle SQL Server Style

This article presents a possible solution to the raffle logistics employed in SQL Server user group meetings around the world.  Read more...
By Alex Tocitu 2011/01/06 | Source: SQLServerCentral.com | Category: random numbers
Rating: |  Discuss |   Briefcase | 3,311 reads

Just for fun

Do you need to take your mind off of the SQL mess you are dealing with? Try my funny words generator.  Read more...
By Peter Sloboda 2010/09/03 | Source: SQLServerCentral.com | Category: word
Rating: |  Discuss |   Briefcase | 2,615 reads

Finding Unique Non-Repeating Random Numbers

Learn three methods of creating random numbers that do not repeat in this article from Brandie Tarvin.  Read more...
By Brandie Tarvin 2010/08/12 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 7,671 reads

Quickly Generate Random number by TSQL with 99.9% Uniqueness Guarntee

Here is the simplest and most efficient technique to guarantee the uniqueness of random numbers.  Read more...
By Namwar Rizvi 2009/09/17 | Source: SQLServerCentral.com | Category: random numbers
Rating: |  Discuss |   Briefcase | 2,000 reads

Random problems

Building random numbers can be challenging for people working in T-SQL. New author Chris Nowicki brings a solution he used to get a random number assigned to each row of a result set.  Read more...
By Chris Nowicki 2009/06/09 | Source: SQLServerCentral.com | Category: random numbers
Rating: |  Discuss |   Briefcase | 5,037 reads

Generating Random Results - SQL School Video

How can you randomly generate data? MVP Andy Warren shows how in this SQL School Video.  Read more...
By Andy Warren 2009/01/15 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 3,163 reads

random integer number scalar function

this produces a random integer between a certain range  Read more...
By Chris Morton 2008/12/12 | Source: SQLServerCentral.com | Category: random numbers
Rating: |  Discuss |   Briefcase | 826 reads

random randomise randomize data query

this is a MUCH simpler method of random randomize randomise rand data from a table  Read more...
By Chris Morton 2008/11/19 | Source: SQLServerCentral.com | Category: random numbers
Rating: |  Discuss |   Briefcase | 263 reads

Generate a random password

If you ever need a quick way to generate random passwords, this is a pretty useful way to do so.  Read more...
By Gaby Abed 2013/05/15 | Source: SQLServerCentral.com | Category: random numbers
Rating: |  Discuss |   Briefcase | 3,292 reads

Create Sample Data Script

in this scripts there are two methods of creating sample data for a gambling application. i have used both cursors and loops.  Read more...
By Chris Morton 2008/10/10 | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 624 reads

Random DEFAULT string for a column using CASE and NEWID

Sometimes you just need to populate a CHAR/VARCHAR column for testing with a random selection of string literals at table CREATE time. Here is a quick and easy script.  Read more...
By Bill Leung 2012/06/14 | Source: SQLServerCentral.com | Category: random numbers
Rating: |  Discuss |   Briefcase | 1,086 reads
   Items 1 to 19 of 19   
 
Tags
rand() (6)    
t-sql (5)    
checksum() (3)    
data generation (3)    
newid() (3)    
test data (3)    
abs() (2)    
sql server 2005 (2)    
always encrypted (1)    
case (1)    
cursors (1)    
default (1)    
deterministic (1)    
funny (1)    
password (1)    
passwords (1)    
raffle (1)    
random data (1)    
random dates (1)    
scalar udf (1)    
seed values (1)    
sql server 2016 (1)    
sql server 7 (1)    
text (1)    
user group (1)    
video (1)    
while loop (1)    
word (1)