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

Articles with tag Random Numbers Rss

Search for any content tagged random numbers

   Items 1 to 9 of 9   
 

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,975 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,519 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,791 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,489 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,546 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,313 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,673 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,165 reads
   Items 1 to 9 of 9